By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,101 Members | 959 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,101 IT Pros & Developers. It's quick & easy.

Dual "Parent-Child" Combo Boxes

P: n/a
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.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.