Austin
09-10-2008, 07:35 PM
My subform query's seem to fail when I view the form not by itself.
How do I call a query on a subform?
For Example here is a query that is called on a subform of frmStudentInfo
SELECT tblClasses.Acad_Discipline FROM tblClasses WHERE (((tblClasses.InstitutionID)=Forms!frmCourseWork!cboInstitution));
Since it is a subform does it need to be Forms!frmStudentInfo!frmCourseWork!cboIntitution ?
EDIT
Figured it out
I changed Forms!frmCoursework!cboInstitution to just
cboInstitution
How do I call a query on a subform?
For Example here is a query that is called on a subform of frmStudentInfo
SELECT tblClasses.Acad_Discipline FROM tblClasses WHERE (((tblClasses.InstitutionID)=Forms!frmCourseWork!cboInstitution));
Since it is a subform does it need to be Forms!frmStudentInfo!frmCourseWork!cboIntitution ?
EDIT
Figured it out
I changed Forms!frmCoursework!cboInstitution to just
cboInstitution