On Wed, 7 Jan 2009 05:48:01 -0800, mike
wrote:

RecordSource: SQL stmt for subform
JOIN (tblTeachers INNER JOIN (tblSubjects INNER JOIN tblStudentSubject ON
tblSubjects.SubjectID=tblStudentSubject.SubjectID ) ON tblTeachers.[Teacher
ID]=tblStudentSubject.TeacherID) ON
tblStudents.StudentID=tblStudentSubject.StudentID ;

This cannot possibly be complete - a query for this purpose must have a SELECT
clause. Please post the entire query (it should start with the word SELECT).
You may also want to post the SQL of the RowSource of the combo box.
--

John W. Vinson [MVP]