Drop Down Boxes to Run Reports

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

Guest

What I am trying to do is have it so a drop down box I created in a form, can
link to a query I am using to run a report.

I have a form that selects a list of cemeteries into a drop down box. My
reports I am creating have to be able to select specific cemeteries, and show
all the people/information in that cemetery.

I don't know how to make it so that when you run a report, you are prompted
for certain information (such as a cemetery for this report). I have seen
them before, and have created a form for easier use on the user end of the
reports. I want to be able to have the drop down box show up and prompt the
user to select a cemetery to be displayed with all the information.

I hope I am specific enough in my request.

Thanks for any help!
 
In query design, refer to your combo box in the criteria under the cementery
field like:

Field: Cementery
Table: MyTableName
....
Criteria: [Forms]![MyForm]![MyComboBox]
 
Back
Top