Query Parameter

[Guest]

I have a report that asks the user to enter a firm name for reporting. The
query behind the report uses a parameter to prompt the user for this
information. Is there a way to turn this parameter into a combo box from
which the user can select a firm name to report on? It would relieve user
from the burden of spelling the firm name correctly when the prompt appears.

 

[Rick B]

This is posted often. Did you try searching for an answer?

You would have to create a new form that contains the combo-box and let them
select it from that form. The query, rather than popping up a paramaeter
box) would simply reference the field from the new form. In the query, it
would look something like this...

=Forms![MySearchFormName]![MyComboFieldName]

I think most of the report in the NORTHWINDS sample database work off a
similar scenario, so you could look there for more information. Or search
for previous posts.


Rick B

I have a report that asks the user to enter a firm name for reporting. The
query behind the report uses a parameter to prompt the user for this
information. Is there a way to turn this parameter into a combo box from
which the user can select a firm name to report on? It would relieve user
from the burden of spelling the firm name correctly when the prompt

appears.

 

[Guest]

Rick,
Thanks - I thought this was the approach I'd have to take but I thought I'd
ask if there was a 'shorter' way rather than create another form.

This is posted often. Did you try searching for an answer?

You would have to create a new form that contains the combo-box and let them
select it from that form. The query, rather than popping up a paramaeter
box) would simply reference the field from the new form. In the query, it
would look something like this...

=Forms![MySearchFormName]![MyComboFieldName]

I think most of the report in the NORTHWINDS sample database work off a
similar scenario, so you could look there for more information. Or search
for previous posts.


Rick B

I have a report that asks the user to enter a firm name for reporting. The
query behind the report uses a parameter to prompt the user for this
information. Is there a way to turn this parameter into a combo box from
which the user can select a firm name to report on? It would relieve user
from the burden of spelling the firm name correctly when the prompt

appears.