By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,987 Members | 1,607 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,987 IT Pros & Developers. It's quick & easy.

Auto Fill Help

P: 4
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
Aug 3 '06 #1
Share this Question
Share on Google+
1 Reply


PEB
Expert 100+
P: 1,418
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
Sep 9 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.