purpose of subform?

  • Thread starter Thread starter mike
  • Start date Start date
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
 
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;
Click to expand...

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,

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 said:
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;
Click to expand...

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.
Click to expand...
 
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:)
Click to expand...

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!
 
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:)
 
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:)
Click to expand...

<high fives and grins all around>

Glad you got such a good reaction.
 
Back
Top