Combo Box that can populate a second combo box

G

Guest

I have a table named "Products". The first field is named "Product Area" which consists of fixed named items such as as "APPL", "COMP", "MP", "SP" and "MGMT". The second field is named "Sub-Product Area" which also has a fixed set of names and is directly related to the first "Product Area" field. For example, I have 10 records for "APPL" but the related "Sub-Product" field varies and the same occurs for the other "Product Area" categories. I would like to create a "Product Area" combo box that will allow me to choose from "APPL", "COMP", "MP", etc. and then populate a second combo box "Sub-Product Area" with those items that are exclusive to the only the specific "Product Area"

I am new to Access so I would appreciate explicit instruction.
 
R

Roger Carlson

This is called the "Cascading Combo Box Problem". On my website (see sig
below) is a small sample database called (oddly enough):
"CascadingComboBoxes", which illustrates how to do this.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

Soroya said:
I have a table named "Products". The first field is named "Product Area"
which consists of fixed named items such as as "APPL", "COMP", "MP", "SP"
and "MGMT". The second field is named "Sub-Product Area" which also has a
fixed set of names and is directly related to the first "Product Area"
field. For example, I have 10 records for "APPL" but the related
"Sub-Product" field varies and the same occurs for the other "Product Area"
categories. I would like to create a "Product Area" combo box that will
allow me to choose from "APPL", "COMP", "MP", etc. and then populate a
second combo box "Sub-Product Area" with those items that are exclusive to
the only the specific "Product Area".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top