By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,426 Members | 2,753 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,426 IT Pros & Developers. It's quick & easy.

Query and combo box to select parameter

P: n/a
Hello

I want to make a parameter query where i can select the parameter out of a
drop down box instead of typing the parameter in a text box.

For example: if i have customers and want to run a query that gives me all
the custormers from a chosen state, that i can choose the state in a drop
down list instead of knowing it by heart and typing it myself.

Does anybody has an idea or example for such a query?

Thx...

Kind regards
Erwin
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Parameters are very limited. You cannot use a combo box to select choices.
You cannot even check that the value entered is in a suitable range.

A simple idea is to create a small form where the user can enter the values.
If the form is open and the values entered on the form, the query will read
the values form the form. For example, you might set the Criteria in the
query to:
[Forms].[Form1].[Text1]

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Erwin Bormans" <er***********@verwijder.dit.telenet.be> wrote in message
news:42*********************@news.skynet.be...
Hello

I want to make a parameter query where i can select the parameter out of a
drop down box instead of typing the parameter in a text box.

For example: if i have customers and want to run a query that gives me all
the custormers from a chosen state, that i can choose the state in a drop
down list instead of knowing it by heart and typing it myself.

Does anybody has an idea or example for such a query?

Thx...

Kind regards
Erwin

Nov 13 '05 #2

P: n/a
"Erwin Bormans" <er***********@verwijder.dit.telenet.be> wrote in message
news:42*********************@news.skynet.be...
Hello

I want to make a parameter query where i can select the parameter out of a
drop down box instead of typing the parameter in a text box.

For example: if i have customers and want to run a query that gives me all
the custormers from a chosen state, that i can choose the state in a drop
down list instead of knowing it by heart and typing it myself.

Does anybody has an idea or example for such a query?

Thx...

Kind regards
Erwin

The easiest way to do this is simply reference the combobox in the query -
so in the criteria row you put:
Forms!MyForm!MyCombo


Nov 13 '05 #3

P: n/a
Many many thx

Kind regards
Erwin Bormans
"Erwin Bormans" <er***********@verwijder.dit.telenet.be> schreef in bericht
news:42*********************@news.skynet.be...
Hello

I want to make a parameter query where i can select the parameter out of a
drop down box instead of typing the parameter in a text box.

For example: if i have customers and want to run a query that gives me all
the custormers from a chosen state, that i can choose the state in a drop
down list instead of knowing it by heart and typing it myself.

Does anybody has an idea or example for such a query?

Thx...

Kind regards
Erwin

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.