I have two combo boxes on a form. The first combo box sets the parameter for the second combo box selection. It works perfect on page 1 of the form. The problem: when I go to a new form the second combo box does not update and does not show the values it should - it is stuck on the values from form page 1. I've tried a manual refresh all and the second combo box does not work.
cboProject: SELECT Project..IDProject, Project.ProjectName FROM Project
cbo2:
SELECT qryProjectToPerson.IDPerson, qryProjectToPerson.PersonLastName, qryProjectToPerson.fkProject
FROM qryProjectToPerson
WHERE (((qryProjectToPerson.fkProject)=[Forms]![frmTest]![cboProject]))
The form recordset type is dynaset.
Any thoughts?
cboProject: SELECT Project..IDProject, Project.ProjectName FROM Project
cbo2:
SELECT qryProjectToPerson.IDPerson, qryProjectToPerson.PersonLastName, qryProjectToPerson.fkProject
FROM qryProjectToPerson
WHERE (((qryProjectToPerson.fkProject)=[Forms]![frmTest]![cboProject]))
The form recordset type is dynaset.
Any thoughts?