Auto Fill Help

[qwas2123]

Hi, Im trying to build a form that within the form it has a feature that if you input data into a certain text box, from there, it will automatically fill the rest of the text boxes on the form based on the information of specific tables.

Example : ID___________
Name "auto" ____________
Loc "auto" ____________
Rank "auto" ____________

etc . . .

I think that i have already created the appropriate relationships between the tables and that all i have to do is create the expression.
now im not to skilled within the expression building aspect of Access so if someone could either point me in the right direction and/or tell me the code.

I greatly appriciate any help i can get . Thank You

[PEB]

So to use the option Auto fill in Access You should use combobox text field!

In the recod source property of the combobox you have to assigne the field from the table from which do you want to get the information

And set the Auto Expand property of the combobox to Yes!

It's everything that you have to do! :)

Have a nice day

Vladimir