Lookup Boxes in Queries and reports

C

Curtt Perry

I have created a parameter query and a report connected to
that query. Currently when you run the report it ask for
the "customer name". Instead, I would like a drop down
box to appear when the report is run and the user simply
chooses the desired customer and the report runs for that
customer. This way if they are not sure of the exact name
of the customer they can scan a list and choose the
correct name(makes it more user friendly too). How do i
do this? This is my first time seeking help online.
Thanks
 
L

Larry

-----Original Message-----
I have created a parameter query and a report connected to
that query. Currently when you run the report it ask for
the "customer name". Instead, I would like a drop down
box to appear when the report is run and the user simply
chooses the desired customer and the report runs for that
customer. This way if they are not sure of the exact name
of the customer they can scan a list and choose the
correct name(makes it more user friendly too). How do i
do this? This is my first time seeking help online.
Thanks
.
create a form with a combo box and run the report from a
button on the form
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top