purpose of subform?

[mike]

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;

ControlSource cboStudent: tblStudentSubject_StudentID

 

[John W. Vinson]

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.

 

[mike]

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

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]

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

Good luck! Sure hope you don't encounter the dread "Demo Effect": an app which
works perfectly in test fails spectaularly when demonstrated before the High
Muck-a-Mucks <g>.

Glad to have been of assistance!

 

[mike]

demo went well today. its the first piece of software i've ever created
that's actually being used. teachers liked it b/c it makes their life
easier. based on some feedback going to add a few items which is easy to do
since you guys taught me to use tables and relationships.

regards to you, Allen, and Gina

 

[John W. Vinson]

demo went well today. its the first piece of software i've ever created
that's actually being used. teachers liked it b/c it makes their life
easier. based on some feedback going to add a few items which is easy to do
since you guys taught me to use tables and relationships.

regards to you, Allen, and Gina

<high fives and grins all around>

Glad you got such a good reaction.