Access queries with dropdowns list for parameters?

[Emily Bright]

How can I make a query so that the criteria for the parameters are a drop
down list of the values in that field. For example, if the field is "Country
of Project", the user can choose from the available countries via a drop down
list rather than enter in "Kenya" in the criteria box. Also, is it possible
to let the user select more than one country (via using the Control botton
while selecting?) from this drop down list? I've been trying to figure this
out for days. ANY HELP would be greatly appreciated!! Thanks.

 

[Rick Brandt]

How can I make a query so that the criteria for the parameters are a
drop down list of the values in that field. For example, if the
field is "Country of Project", the user can choose from the available
countries via a drop down list rather than enter in "Kenya" in the
criteria box. Also, is it possible to let the user select more than
one country (via using the Control botton while selecting?) from this
drop down list? I've been trying to figure this out for days. ANY
HELP would be greatly appreciated!! Thanks.

The self-prompting parameter feature in Access queries is very limited and
seldom used in a "production quality" application. If you want the user to
be able to select from a list you need to use a form and have the query
reference a ComboBox on the form for its parameter instead of using the
[Enter your parameter] method in the query.

 

[unicycle kid]

How can I make a query so that the criteria for the parameters are a
drop down list of the values in that field. For example, if the
field is "Country of Project", the user can choose from the available
countries via a drop down list rather than enter in "Kenya" in the
criteria box. Also, is it possible to let the user select more than
one country (via using the Control botton while selecting?) from this
drop down list? I've been trying to figure this out for days. ANY
HELP would be greatly appreciated!! Thanks.

The self-prompting parameter feature in Access queries is very limited and
seldom used in a "production quality" application. If you want the user to
be able to select from a list you need to use a form and have the query
reference a ComboBox on the form for its parameter instead of using the
[Enter your parameter] method in the query.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

How can I use a list box or a combo box in a form as a query parameter

 

[Pirduan]

Hi Rick,

I have a similar problem. I've created a combo box with a list of topics
which the user can select.
In my Query window under Criteria, I've type: =
[Forms]![SelectCategory].[Combo2]

When I run my query, it does not capture the value i selected from the combo
box.

I tested my query using just a specific value; eg in Criteria, I keyed in
"*SAP*", and i return all the items which is related to SAP.

Care to help.

How can I make a query so that the criteria for the parameters are a
drop down list of the values in that field. For example, if the
field is "Country of Project", the user can choose from the available
countries via a drop down list rather than enter in "Kenya" in the
criteria box. Also, is it possible to let the user select more than
one country (via using the Control botton while selecting?) from this
drop down list? I've been trying to figure this out for days. ANY
HELP would be greatly appreciated!! Thanks.

The self-prompting parameter feature in Access queries is very limited and
seldom used in a "production quality" application. If you want the user to
be able to select from a list you need to use a form and have the query
reference a ComboBox on the form for its parameter instead of using the
[Enter your parameter] method in the query.

 

[tina]

your manual test used the asterisk wildcard, but your form reference
criteria did not - so unless you have a category which is called "SAP",
you're not going to get anything that way. add the asterisks to the form
reference criteria, as

"*" & [Forms]![SelectCategory].[Combo2] & "*"

hth

Hi Rick,

I have a similar problem. I've created a combo box with a list of topics
which the user can select.
In my Query window under Criteria, I've type: =
[Forms]![SelectCategory].[Combo2]

When I run my query, it does not capture the value i selected from the combo
box.

I tested my query using just a specific value; eg in Criteria, I keyed in
"*SAP*", and i return all the items which is related to SAP.

Care to help.

How can I make a query so that the criteria for the parameters are a
drop down list of the values in that field. For example, if the
field is "Country of Project", the user can choose from the available
countries via a drop down list rather than enter in "Kenya" in the
criteria box. Also, is it possible to let the user select more than
one country (via using the Control botton while selecting?) from this
drop down list? I've been trying to figure this out for days. ANY
HELP would be greatly appreciated!! Thanks.

The self-prompting parameter feature in Access queries is very limited and
seldom used in a "production quality" application. If you want the user to
be able to select from a list you need to use a form and have the query
reference a ComboBox on the form for its parameter instead of using the
[Enter your parameter] method in the query.

 

[Pi]

Hi Pirduan,

You have to requery the combo box after you select the data. Use the On
Exit event: me.combo2.requery.

Kathleen

Hi Rick,

I have a similar problem. I've created a combo box with a list of topics
which the user can select.
In my Query window under Criteria, I've type: =
[Forms]![SelectCategory].[Combo2]

When I run my query, it does not capture the value i selected from the combo
box.

I tested my query using just a specific value; eg in Criteria, I keyed in
"*SAP*", and i return all the items which is related to SAP.

Care to help.

How can I make a query so that the criteria for the parameters are a
drop down list of the values in that field. For example, if the
field is "Country of Project", the user can choose from the available
countries via a drop down list rather than enter in "Kenya" in the
criteria box. Also, is it possible to let the user select more than
one country (via using the Control botton while selecting?) from this
drop down list? I've been trying to figure this out for days. ANY
HELP would be greatly appreciated!! Thanks.

The self-prompting parameter feature in Access queries is very limited and
seldom used in a "production quality" application. If you want the user to
be able to select from a list you need to use a form and have the query
reference a ComboBox on the form for its parameter instead of using the
[Enter your parameter] method in the query.

 

[Imran]

Same problem here. Still unable to resolve it. kindly help.

Hi Rick,

I have a similar problem. I've created a combo box with a list of topics
which the user can select.
In my Query window under Criteria, I've type: =
[Forms]![SelectCategory].[Combo2]

When I run my query, it does not capture the value i selected from the combo
box.

I tested my query using just a specific value; eg in Criteria, I keyed in
"*SAP*", and i return all the items which is related to SAP.

Care to help.

How can I make a query so that the criteria for the parameters are a
drop down list of the values in that field. For example, if the
field is "Country of Project", the user can choose from the available
countries via a drop down list rather than enter in "Kenya" in the
criteria box. Also, is it possible to let the user select more than
one country (via using the Control botton while selecting?) from this
drop down list? I've been trying to figure this out for days. ANY
HELP would be greatly appreciated!! Thanks.

The self-prompting parameter feature in Access queries is very limited and
seldom used in a "production quality" application. If you want the user to
be able to select from a list you need to use a form and have the query
reference a ComboBox on the form for its parameter instead of using the
[Enter your parameter] method in the query.

 

[Douglas J. Steele]

Are you certain that the combo box is bound to the column you think it is?
In otherwords, does [Forms]![SelectCategory].[Combo2] return the value you
think it should?

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Same problem here. Still unable to resolve it. kindly help.

Hi Rick,

I have a similar problem. I've created a combo box with a list of topics
which the user can select.
In my Query window under Criteria, I've type: =
[Forms]![SelectCategory].[Combo2]

When I run my query, it does not capture the value i selected from the
combo
box.

I tested my query using just a specific value; eg in Criteria, I keyed in
"*SAP*", and i return all the items which is related to SAP.

Care to help.

Emily Bright wrote:
How can I make a query so that the criteria for the parameters are a
drop down list of the values in that field. For example, if the
field is "Country of Project", the user can choose from the available
countries via a drop down list rather than enter in "Kenya" in the
criteria box. Also, is it possible to let the user select more than
one country (via using the Control botton while selecting?) from this
drop down list? I've been trying to figure this out for days. ANY
HELP would be greatly appreciated!! Thanks.

The self-prompting parameter feature in Access queries is very limited
and
seldom used in a "production quality" application. If you want the
user to
be able to select from a list you need to use a form and have the query
reference a ComboBox on the form for its parameter instead of using the
[Enter your parameter] method in the query.

 

[Imran]

Here is the Solution.

http://www.microsoft.com/office/com...osoft.com/office/community/en-us/settings.xml