Combo Box - 2 columns of dependent data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to set up a form that allows a user to choose a Customer Group
first in a Combo Box. Then, in a second box the user will choose a SIC code.
The issue is that there are hundreds of potential SIC codes for each Cust
Group. Is there a way to allow the SIC code input list to be limited to the
Customer Group selected?
Ex: If Cust Grp A1 is selected in Combo Box 1, then show only SIC Codes 1-60
in Box 2. If Cust Grp A2 is chosen, then show only 61-150 in Box 2 to be
selected?

Appreciate any help on this.
 
THANKS SO MUCH..Works like a charm. Do need to figure out the formula though
 
You must log in or register to reply here.

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

Similar Threads

Linking Two Combo Boxes 2
Multiple dependent combo boxes 1
cascading combo display is blank sometimes (Access 2007) 2
Combo Box interacting to Table 8
Getting a value by comparing 2 columns 1
Combo Box 1
Find name in subform using cbox and go to that record # in main fo 2
bound column and queries 3

Back
Top