This will take a little bit of SQL and VBA.
Let's assume for simplicity the form will only contain a listbox and a command button.
The listbox should be bound to a query that returns all possible attendees and their ID if applicable.
In the list box properties you want to set "Multi Select" to "Extended" this will allow users to select more than one row in the listbox by either shift+click or ctrl+click or a combination of both.
The command button will have an onclick event. This is where you will iterate through the selected items of the listbox to build a criteria string. This string will be used to "filter" your report. This button will also open the report only showing the selected attendees.
Of course you will need to have a query that returns all the information for all possible attendees and you will need to make a report based off that query as well.
Assuming our list box is called lstAttendees and our command button is cmdGenerateReport the VBA would be something like the following:
-
Private Sub cmdGenerateReport_Click()
-
'Declare a string variable
-
Dim strCriteria As String
-
-
'Intialize string variable
-
strCriteria = "attendeeID IN ("
-
-
'Iterate through selected items in the list box
-
For Each varItem In Me.lstAttendees.ItemsSelected
-
'Add selected item to the criteria string
-
strCriteria = strCriteria & Me.lstAttendees.ItemData(varItem) & ","
-
Next varItem
-
-
'Trim trailing comma and add closing bracket
-
strCriteria = Left(strCriteria, Len(strCriteria) - 1) & ")"
-
-
'Open the report
-
DoCmd.OpenReport yourReport, acViewPreview, , strCriteria, acWindowNormal
-
-
End Sub
-
yourReport would be the name of the report you have created
attendeeID would be the field name for bound column of the list box
This is a basic outline of what you would need to do. You should be able to modify this to suit your needs.