Combobox question

[dealwi8me]

Hello,

I have a combobox that uses a query as a row source. The query has 3 columns (ID, Description, Code). In the combobox at the form i only show the Description and when user choose I save the ID to a table. The problem is that i want to use the Code field as well (without appearing on the form).

Any suggestions how to do that?

Thank you in advance!

 

[Dennisk]

use the column method of the combo box to refere to each column in the list.

yourComboBox.Column(2) refers to the third column. numbering starts from 0.

 

[dealwi8me]

that works! thank you for the help!