Paramater Query with drop down menu

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?
 
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.
 
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
 
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.
 
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?
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

Passing parameters via MS Query to Access 1
Custom Form Property, Parameter Query Access 2007 Problem 2
Drop Down Properties 1
Invalid Parameters 2
How do I make query parameters with a drop down list? 1
A paramater based on another paramater's results?? 1
Paramater query in a crosstab query in access 2003 1
Office 2007 - rename query problem 1

Top