Passing values to a report from a form in Access 2013

[InspectorHound]

Hello,



I have a form that uses a query to display records for a number of people after search criteria is entered. Say for example 10 people are returned to the form. I then have a button that calls a report. The report has its own query. I want to pass the ids of the ten people displayed on the form to the report.

I can do that when one person is displayed -- take the value of the text box and use it in the where clause of the command calling the report. But how do I do it when ten people are displayed?

[June7]

Here is one example of selecting multiple parameters for a single field as filter criteria: http://allenbrowne.com/ser-50.html

And example of building multi-field filter criteria http://www.allenbrowne.com/ser-62.html

If the form's filter property is set with the parameters by the search operation, then:

DoCmd.OpenReport "reportname", , , Me.Filter