Use a Multi-Select Listbox to Filter a Report
There are a number of ways to do this. The one I usually use is to have the report based on a query that returns all records, and use the wherecondition argument of OpenReport to restrict the records. It is a little trickier with a multiselect listbox, but the code would look like this:Dim strWhere As String
'trim trailing comma
strWhere = Left(strWhere, Len(strWhere) - 1)
'open the report, restricted to the selected items
DoCmd.OpenReport "rptEmployees", acPreview, , "EmpID IN(" & strWhere & ")"
Multiselect sample db