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" wrote:

On Tue, 6 Jan 2009 17:16:05 -0800, mike
wrote:

john,

i click new record and when i select a student from the cbo i get the
following dialog box: "The object doesnt contain the Automation object
StudentID..." which only started happening after i rebuilt my subform using
new tables/fields, any idea what's the cause of this?

What's the Recordsource for the subform (post the SQL)? What's the Control
Source of the combo?

My guess is that the combo has a control source that is not a fieldname in the
new table.
--

John W. Vinson [MVP]