PDA

View Full Version : Solved: Sync'ed Combo Boxes quit working on subform



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

Austin
09-11-2008, 06:52 AM
A great document on how to interact with elements can be found at
http://www.mvps.org/access/forms/frm0031.htm