Access: How to automatically fill in the rest of the fields

no strictly web related..

[humpingdan]

I have a database, table which lists all the banned users of a network username - firstname - surname - jobdesc, what i want to be able to do is create a form which when i enter the username it automatically fills in the rest of the fields i.e firstname & surname

any suggestions or points of reference, i just need to know what to search for?

Thanks

Dan

[mattur]

There's lot of useful articles in the Microsoft Knowledgebase explaining how to do tasks like this.

Try How to Use a Bound Control to Find a Record [support.microsoft.com]

HTH

[Lilliabeth]

In the form header:

Launch the combo box wizard and choose the option "Find a record in my form based on the option I select in the combo box"

In the next step, choose the username field.

You're done.

You don't have to use the combo as a drop-down, you can just type the value in if you want.

[humpingdan]

Thats great,

for instance i have a table where a number of entries are the same name, Surnames!

i.e

Mohammed Ali x 10.

i need to show a list of all the ali's in my table/database?

search for ALI

Results
Mohammed Ali
etc ALi
Etc Ali

Help!

[Lilliabeth]

i need to show a list of all the ali's in my table/database?

You could just create a query or if you want a form, create a continuous form and use either the Filter by Form tool or the Filter by Selection tool.