Drop down list in query

dspinner

Registered User.
Local time
Today, 21:30
Joined
Sep 26, 2002
Messages
16
In a database with a list of periodicals, i have a table for categories. I have a query the allows the user to type in what category they are searching for. Is there a way in that query to provide a drop down box when it is launched rather than the "fill in the blank"?
 
You need to create a combo box on a form and then reference it in the query as criteria

i.e.

[Forms]![MyForm]![MyCombo]
 

Users who are viewing this thread

Back
Top Bottom