Combo Boxes

[Ivan]

I have 3 cbs(combo boxes). I want any of those 3 cbs to fill the other 2 cbs with their corresponding values when a choice has been made. Example:

ID : Autonumber
Name : Ivan cb1
LastName : Olmedo cb2
Company : NEXTECH cb3

If I choose Olmedo from cb2, I want cb1 and cb3 to show their corresponding values according to the value chosen in cb2. So cb1 will show "Ivan" and cb3 will show "NEXTECH".

Please I need help with this.

It would be greatly appreciated.

Thanks in advance.

 

[lorenzoaj]

Ivan,

I believe this is what you are looking for. I have put mine in the After Update of the Combobox that the selection is made from. I'm not sure about the Column #'s. You might have to switch the numbers.

Me.cb1 = Me.cb2.Column(2)
Me.cb3 = Me.cb2.Column(4)

I hope this helps

AJ

 

[MW]

I've tried doing this. I got it to display the data from the correct field, but I wanted it to save that data into a corresponding field in another table, but couldn't figure out how to get it bound to another field if it's already referencing the field in the combo box.

Any suggestions?
Thanks