Drop Down List Prompt

[KLock]

I know how to edit a query to have a prompt box asking for a select criteria
(ie. in criteria selection enter [Enter Text Here].

So my question is there a way to create a prompt criteria that is a drop
down box selection?

 

[Jeff Boyce]

You don't do that in a query.

Create a form that has your combobox. Modify your query to point to the
form's combobox.

Note: the query won't work properly if you don't have the form open and
don't have a value selected.

Regards

Jeff Boyce
Microsoft Office/Access MVP