text box to display combo column not key column

[MyWaterloo]

I have a text field that I want to display the name that is chosen in a combo box (=[Combo12]). Unfortunately the text box is only displaying the number of the record in the key column. What do I have to do to have it show what is in column 2 of the combo box instead of column 1?

[ClearRift]

The combobox uses the key column to look up the correct values to place in the box. Therefore, you need to do the same thing. This is most easily done using the dlookup function like so:
syntax: DLookup(Expression, Domain , Criteria)

=dlookup("[ColumnYouWant]","[YourTable]","[KeyColumn] = [Combo12]")

Let me know if this helps.

[mshmyob]

Try using the column property of the combo box.

Me.cboBox.column(1) would give you the column info you want.

Me.cboBox.Column(0) is what you are getting

See if that helps.

cheers,

[MyWaterloo]

Thanks mshmyob, that worked great!

[mshmyob]

You're welcome. Good luck with the rest of your project.

cheers,