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]