C
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?
select from a drop down menu. Can anyone help?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
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.
you can't easily provide defaults, you can't check for reasonable entries,...
Use controls on forms for all user interaction.
M
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
Access doesn't have that capability. You need to set something up using a
form and combobox.
God Bless,
Mark A. Sam
C
CCWilson
Do I reference that form in the criteria for that field?
M
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.
Where [Form1] is your form name and [Text0] is the controlname, usually a
textbox or combobox.
C
CCWilson
thanks for your help.
Mark A. Sam said: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 said:Do I reference that form in the criteria for that field?