Drop Down List Prompt

  • Thread starter Thread starter KLock
  • Start date Start date
K

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?
 
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
 
Back
Top