How to choose a certain column from a combobox for a query criteria

[database_1]

I have a sub query which is filtered using a combo box on a form. I was able to get the ID of the combo box values but I now want to use the actual names seen on the combo box to use as criteria. I figured out using a msgbox that I can get the name of the combo box values by using me.combobox.Column(1). I then tried to add this to the criteria box in my query but it does not seem to allow the code Forms!Search_frm!combobox.column(1). I am assuming it is the .column(1) since that is the only thing I really changed. Am I writing the criteria code wrong or is there an easier way to do this? Thanks for your time.

[Gicu]

Add a hidden textbox to your form (txtSelectedName), make its control source Forms!Search_frm!combobox.column(1) then use it in your query's criteria row Forms!Search_frm!txtSelectedName.

Cheers,

[June7]

Why use name instead of ID? Names are poor unique identifiers.