Returning text from fields populated by combobox.

[Goodtilitsgone10]

I have a table in which contains records entered by various users via a form. This form contains comboboxes which I have learned populate the related field with an ID rather than the selected data from the combobox.

Users then use another form to search the same table to find records.

The issue is when someone searches for records the fields populated by comboboxes show the ID and not the selected text. How can I have the search form return the original data selected from the combobox?

[ranman256]

if you dont need the ID, then set the combo box.BOUND COLUMN to the text field instead of the id.

if you MUST keep the ID field as bound, then put another unbound text box on the form. (invisible if you want)
in the combo.AFTERUPDATE event when the user chooses the item, set the text box to the text in the combo.

sub combo_afterupdate()
  txtbox = combo.column(1)
end sub

this fills the text box with the column holding the text.

[Goodtilitsgone10]

Setting the Bound Column to the column of interest works. I could have sworn I tried this before like three weeks ago and all it did was delete the list in the combobox. I was lost and thought I had to build a query and link tables to point at the field of interest so and put that into the code for the search form JUST so that users would see a name rather than a number. I am glad I do not have to do that. I don't care if this makes the database less efficient; the table will never have tens of thousands of records or anything like that.

Thanks for the help ranman256.