Query Parameter

D

DaveK

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

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




DaveK said:
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
Click to expand...
appears.
 
D

DaveK

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.

Rick B said:
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




DaveK said:
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
Click to expand...
appears.
Click to expand...
 
Top