Query using dropdown

[dmkennard2]

Hi,
I have a query that users have to put in a search criteria. I have used the LIKE statement in the query.
I would like the users to be able to choose a value from a dropdown list based on a table rather than having to type in a value manually.
Is this possible?

Thanks in advance

 

[lupins46]

You have to run the query from a form.
On the form build a combo box based on the values you want to selct from and then use the combo as the criteria in the query:

Forms!formname!comboname

 

[dmkennard2]

Thanks.
This works fine. I thought i saw somewhere once that it is possible to do from the query!

Thanks

 

[lupins46]

No it is not.