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.

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]

thankyouthankyouthankyouthankyou!
very much appreciated!

you're welcome :)