Paramater Query with drop down menu

  • Thread starter Thread starter CCWilson
  • Start date Start date
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?
 
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.
 
CC,

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

God Bless,

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.
 
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?
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Invalid Parameters 2
using lookup values with query prompts 1
Drop Down Properties 1
Passing parameters via MS Query to Access 1
A paramater based on another paramater's results?? 1
Drop down Menu for Prompts 2
Why is my copied Query is keeping parameters? 4
Query with drop down box 2

Back
Top