John,

I recreated the subform and when doing so realized the errors.

I'm rolling it out at our staff mtg tomorrow. Cant thank you enough. I
learned a lot about access the past 2 wks thanks for the advice

"John W. Vinson" wrote:

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]