Open a report with multiple criteria selected from a form

[David Ball]

Hi,

I have a form, frmSelectProjects, where I can select multiple criteria to run the query, qryJC_Manhours_By_Projects.
I have created a report, rptJC_Manhours_By_Projects, based on the query but I need to be able to select multiple criteria (Projects) before the report runs. I don’t know how to have the form open, allow me to select Projects, and then run the report.
I have attached the database.
What do I need to do?
Thanks very much
Dave

 

[bob fitz]

The attached shows one way that this might be done.
Let me know if you need any explanation of the method used.