Code:
SELECT DISTINCT Students.ID AS StudentID, Sessions.ID AS SessionID, Students.FlightPath, Students.PreProf, Students.HC, Students.Path, Students.USP, Students.SSN, Students.First, Students.Last, [Group Advising].locationName AS locname, [Group Advising].Time AS StartTime, Students.PIN, Students.Major, Students.Class, Sessions.Session, Sessions.Session AS SessionName
FROM (Students LEFT JOIN Sessions ON Students.Session = Sessions.ID) LEFT JOIN [Group Advising] ON Students.GroupAdvisingSessionID = [Group Advising].GroupAdvisingRecordID
WHERE (((Sessions.ID)=[Forms]![ReportsSession]![SessionCombo]) AND ((Students.FlightPath)=[Forms]![frmGroupReports]![lstBxFlightpaths]));
Originally Posted by
mreniff
The value is ""
I remed out 'strWhere = Left(strWhere, Len(strWhere) - 1) and the last section of "Report No In (" & strWhere & ")", acWindowNormal
The report immediately open, as it did before, but the listbox will not allow for multi-selection of report.
With Multselect set to Simple or Extended, the reports are opening without any data.