Drop Down Boxes to Run Reports

[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!

 

[Guest]

In query design, refer to your combo box in the criteria under the cementery
field like:

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