Code to select second column from Combo box

[DarkAngel]

I have a combo box with data source as a query. I want to select another field in the query from the record which is currently selected to use. Is there an easy way to do this?

Thanks,
Paul

 

[boblarson]

You can refer to any column in the selected item in the combo box, regardless of which column is the bound column, by using:

Me.YourComboBoxNameHere.Column

n being a number from 0 to the number of columns in the query minus 1 (it is zero based so the first column is referred to by 0, the second by 1, etc.