Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Drop down Menu for Prompts

3 views
Skip to first unread message

ShrinePP92

unread,
Jul 30, 2006, 5:28:01 PM7/30/06
to
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.

Rick Brandt

unread,
Jul 30, 2006, 5:34:57 PM7/30/06
to

The built in paramater prompting is very limited and is seldom used in a serious
app. Instead you should open a form first that has the TextBoxes and ComboBoxes
that the user fills out and then replace the paramater markers in your query
with references to that form.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


fredg

unread,
Jul 30, 2006, 5:37:18 PM7/30/06
to

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.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

0 new messages