How to get certain fields to populate

S

soonerj

I have a table that stores client ID numbers, names, addresses, phone
#s, etc. I've got a form created with the client IDs in a drop down
menu and all other fields are text boxes. What I want is that you
would select the client ID and the names, addys, etc will populate.
How do I do this?
 
J

jahoobob via AccessMonster.com

After you have the form with all the fields you want, use the combobox wizard
and select the third choice on the first screen. The rest of the wizard
should lead you where you want to go.
 
A

Access101

No offense, but did you just create a form that is based on the bound combo
box, but all the other text boxes are unbound (not based on the table)?

If so, you would need to create a form based on all fields in the table, not
just the combo box.
 
J

jahoobob via AccessMonster.com

No offense taken, but I did say with all the fields you want, implying that
they are bound to the fields of the table/query.
No offense, but did you just create a form that is based on the bound combo
box, but all the other text boxes are unbound (not based on the table)?

If so, you would need to create a form based on all fields in the table, not
just the combo box.
After you have the form with all the fields you want, use the combobox wizard
and select the third choice on the first screen. The rest of the wizard
Click to expand...
[quoted text clipped - 5 lines]
Click to expand...
 
Top