Filtering... Drop down boxes that are dependent upon each other.

[Guest]

I have a work order. Within the work order, i need to create two drop down
lists that provides data that is dependent upon each other.
*Example*
Drop Down Boxes: 1) Branch 2) Section
If you select one of the items in the Branch drop down list, I need the
Section drop down list to provide only items that pertain to the specified
branch.
Aftwards, the customer selects the Section that they are referring to
regarding the work order.
Thank you for helping.

 

[Rick B]

Do a search. Asked and answered all the time. Look for "cascading combo
box"

 

[Guest]

CityGal,

Here's the link to an example. Just scroll down to the "cascading combo".
It should give you all the info you need.

http://www.candace-tripp.com/pages/access_downloads.aspx

HTH

Aaron G
Philadelphia, PA