Multi Select field as Query Qualifier

[brian]

I have a list of choices in a field on a form that I want to pass to a Query
and use and IN statement to select. I keep getting no records returned.
Here is the SQL: SELECT Attendees.AttendeeLastName & ", " &
Attendees.AttendeeFirstName AS AttendeeName, Registration.StartDate,
Facility.FacilityName, Courses.EventName AS Course, IIf([Completed]=True,1,0)
AS Complete, IIf([Incomplete]=True,1,0) AS NotComplete, IIf([No
Show]=True,1,0) AS NoShow, IIf([Completed]=False And [Incomplete]=False And
[No Show]=False,1,0) AS Scheduled, 0 AS NotScheduled, Attendees.GroupID,
Attendees.RoleID, Registration.StartTime, Attendees.Designation
FROM Facility INNER JOIN (Courses INNER JOIN (Attendees INNER JOIN
Registration ON Attendees.AttendeeID = Registration.AttendeeID) ON
Courses.EventID = Registration.EventID) ON Facility.FacilityID =
Attendees.FacilityID
WHERE (((Courses.EventName) In ([forms]![rptFacility]![Course])) AND
((Attendees.FacilityID)=[forms]![rptFacility]![FacilityID]))
ORDER BY Attendees.AttendeeLastName;

 

[Duane Hookom]

This won't work as you expect. There are quite a few examples on the web that
show the code required to use a multi-select list box for filtering a form or
report.

There is a generic (but slow) function and sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.