Show data from table via dropdown combo?

[crow]

I have a database with our client list as a field which is a combo dropdown box. What I would like to do is when I choose a customer from the combo box is have it display all of the information in the various fields for that customer. The client in the primary key and we keep updating each client as we do any dealing with them in a notes field. Is there a way to make this happen. I thought that maybe the onFocus might work but I didn't have any luck with it. Any suggestions would be greatly appreciated! Thanks

 

[dopedealer]

When you select the option from the combo box and the data gets pulled and fills all the fields for that option do you want the data to be editable? Do you want to be able to make changes?
Chris

 

[crow]

Display Data from combo box

Yes. The data does need to be editable.

 

[dopedealer]

I will make you a dummy sample and you can use that to understand and implement/ change accordingly to your needs, give me 20 minutes.
Chris

 

[dopedealer]

Delete the Combo Box and add a new one, when your adding it you will see the wizard come up with 3 options, the third option says "Find a record on my form based on the value i selected in my combobox" choose that and then the table which you want the control to "Control", also choose the fields you want in the Combobox, ideally the primary key and another field of your choice and voiala that should work.
Attached is an example.
Chris

 

[crow]

Data Display

Thank you very much.