Lookup Boxes in Queries and reports

  • Thread starter Thread starter Curtt Perry
  • Start date Start date
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
 
-----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
Click to expand...
button on the form
 
Back
Top