Set rs1 = CurrentDb.OpenRecordset(SQL, dbOpenSnapshot)
The above line is highlighted with the error
SQL = "SELECT Exam.StudentID, Student.LastName, Student.FirstNames, Exam.ExamDate, Exam.ExamTime, StudentCourse.CourseStatus, StudentCourse.SerialID, " & _
"StudentCourse.PrintCertificate, Exam.InstructorID, Student.[Prov Exam Language], IIf(Nz([Prov Exam Language])=1,'','French') AS [Language] " & _
"FROM Student INNER JOIN (StudentCourse INNER JOIN Exam ON StudentCourse.StudentCourseID = Exam.StudentCourseID) ON Student.StudentID = Exam.StudentID " & _
"WHERE (((Exam.ExamTime) = [Forms]![frmExamSerial]![cboTime]) And ((StudentCourse.CourseStatus) = 'Registered' Or (StudentCourse.CourseStatus) = 'In Progress' " & _
"Or (StudentCourse.CourseStatus) = 'Completed') And ((StudentCourse.SerialID) = [Forms]![frmExamSerial]![cboSerial])) ORDER BY Student.LastName, Student.FirstNames;"
The SQL statement is copied from the SQL statement of a query.
What needs to be repaired in the SQL statement?
Thanks in advance