Dual "Parent-Child" Combo Boxes

[Jeff_F]

Hi all. Question in two parts. I'm looking to add two combo boxes.
The first will contain regions and the second will contain employee
names which correspond to the region selected in the first combo box.
What is the most efficent way to go about this type of layout - in
terms of code and populating the combo box??? thx.

[Wayne Morgan]

You need to base the Row Source of the child combo on a query that refers to
the Parent combo in its WHERE clause.

Example:
SELECT PersonID, PersonName FROM tblPeople WHERE
Region=Forms!frmMyForm!cboParentCombo

In the AfterUpdate event of the Parent combo, issue a Requery to the Child
combo.

Example:
Me.cboChildCombo.Requery

--
Wayne Morgan
MS Access MVP
"Jeff_F" <ki*******@aol.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

Hi all. Question in two parts. I'm looking to add two combo boxes.
The first will contain regions and the second will contain employee
names which correspond to the region selected in the first combo box.
What is the most efficent way to go about this type of layout - in
terms of code and populating the combo box??? thx.