Query Parameter

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
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...
 
Back
Top