Drop down Menu for Prompts

S

ShrinePP92

I have set up a prompt in the Criteria Line [What Dept?], but how do I get
the prompt to have a drop-down menu? The item in the Table I use for
"Department" is a "Combo Box" for the Lookup. The drop down menu shows up in
the form, but not the prompt in the query.
 
F

fredg

I have set up a prompt in the Criteria Line [What Dept?], but how do I get
the prompt to have a drop-down menu? The item in the Table I use for
"Department" is a "Combo Box" for the Lookup. The drop down menu shows up in
the form, but not the prompt in the query.
Click to expand...

You can't get that drop-down in the query prompt.

You'll need to create a form, with the combo box, and change (in the
query) [What Dept?] to
Forms!FormName!ComboName

Make sure the datatype of the bound column of the combo box matches
the datatype of the field in the query.
Change FormName and ComboName to whatever the actual names of the form
and combo box are.

The form must be open when the query is run.
 
Top