combo box problem

[sammy16]

I have a form with 4 combo boxes. One of the combo box's source data comes from a table with 6 columns but only the first column is bound when selected. Is there anyway I can have more than one value as I need to use one of the other colums for a select statement in the code update() to enter a value in the last combo box.

 

[KenHigg]

Can you use the value you are currently getting form the combo, and use it in a dLookup() to get the other value?

ken

 

[sammy16]

unfortunately no as the value held inthe first combo box is not unique it is an area code with many regions for the one area. I want to display the region code for that particular selection.