Combo box on new (next) form not updating (1 Viewer)

TB11

Member
Local time
Today, 07:54
Joined
Jul 7, 2020
Messages
78
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?
 

GPGeorge

Grover Park George
Local time
Today, 05:54
Joined
Nov 25, 2004
Messages
1,775
Please explain what you mean by "page 1 of the form" and "next" in this context?
The problem is that terms in Access (as in other software development) have precise meanings, and that means if you use an ambiguous term like "page 1", it doesn't really convey enough context. Thanks.
 

TB11

Member
Local time
Today, 07:54
Joined
Jul 7, 2020
Messages
78
Sorry. Page =1 Record 1, New Page = Add new record
 

June7

AWF VIP
Local time
Today, 04:54
Joined
Mar 9, 2014
Messages
5,423
This is known as cascading combobox. Make selection in first combobox and requery second combobox.
 

Users who are viewing this thread

Top Bottom