Combo Box that can populate a second combo box

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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"
Click to expand...
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".
 
Back
Top