If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#34
|
|||
|
|||
purpose of subform?
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] |
Thread Tools | |
Display Modes | |
|
|