Using more than 1 field from a COMBO BOX 2

[cschnable]

I know how to select which collumn I want to use from a combo box in that field.

But how can I use the second collumn from the same selected row in the combo - FOR ENTRY INTO ANOTHER FIELD ON THE SAME FORM?

 

[Vidar13]

If the combo box field is based on a table/query, you can simply use the other fields from that same table/query to populate the other fields on your form. The easiest way is to code the after update event of the combo box to set the other form fields value to the value you want.