Paramater Query with drop down menu

[CCWilson]

I want to create a parameter query that prompts for a value that you can
select from a drop down menu. Can anyone help?

 

[Duane Hookom]

IMHO, don't ever use parameter prompts in queries. You can't use drop downs,
you can't easily provide defaults, you can't check for reasonable entries,...

Use controls on forms for all user interaction.

 

[Mark A. Sam]

CC,

Access doesn't have that capability. You need to set something up using a
form and combobox.

God Bless,

Mark A. Sam

 

[CCWilson]

Do I reference that form in the criteria for that field?

 

[Mark A. Sam]

Yes you can do that. Use this syntax: [Forms]![Form1]![text0]

Where [Form1] is your form name and [Text0] is the controlname, usually a
textbox or combobox.

 

[CCWilson]

thanks for your help.

Yes you can do that. Use this syntax: [Forms]![Form1]![text0]

Where [Form1] is your form name and [Text0] is the controlname, usually a
textbox or combobox.

Do I reference that form in the criteria for that field?