View Full Version : Selecting multiple fields from a combo box.


Jim_Noseworthy
04-03-2001, 02:43 PM
I have a database created with one of the fields as a combo box. This box is connected to a table which has three fields. The question is, can I choose a table entry in the combo box and have all three related fields passed to the assigned fields in my database? If so, how so?

Jack Cowley
04-03-2001, 05:26 PM
In the After Update event of the Combo box code similar to this should do the trick...

Me![Field1] = Me![ComboBoxName].Column(0)
Me![Field2] = Me![ComboBoxName].Column(1)
Me![Field3] = Me![ComboBoxName].Column(2)