Like crieria and combo box

[emartel]

Like criteria and combo box

When you put Like [Enter Criteria] into a query criteria row you get a message box which call up data from a certain table column.
How can I get that message box to become a combo or list box displaying a list of all the data available in the column, rather than the user guessing ?

Hope that makes sense.
many thanks in advance.

 

[maxmangion]

you can do that at form level by using an unbound combo box ... then in the criteria row of your query, simply reference that combo box like this:

[Forms]![FormName]![ComboBoxName]

 

[emartel]

thankyouthankyouthankyouthankyou

thankyouthankyouthankyouthankyou!
very much appreciated!

 

[maxmangion]

you're welcome