How to connect Multiple Combo Boxes?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: DMI (DMI_at_discussions.microsoft.com)
Date: 01/12/05 

Date: Wed, 12 Jan 2005 12:19:04 -0800

I am trying to develop a new system. The database is already designed. I am
in the process of creating a form and I would like to use three combo boxes.
The list in each combo box is generated using the prior combo-box. For
example:

combox1 : 2 entries (List of cars) it can be Foreign or National
Depending on what the user selects in combox1 the population in combox2 will
change as follows:

combox2 : IF combox1 is Foreign the list in combox2 will have 4 entries
Mazda, Toyota, VMW, or VW
               IF combox1 is National the list in combox2 will have 2
entries Ford, GM
Depending on what the user selects in combox1 and combox2 the population in
combox3 will change as follows:

Combox3 : IF combox1 is Foreign and Combox2 is Mazda the Combox3 will have
two entries Red, Yellow, Black
                 IF combox1 is National and Combox2 is Ford the Combox3 will
have Four entries Green, Orange, Blue, Pink
                 IF combox1 is Foreign and Combox2 is Toyota the Combox3
will have thee brown, white, gray
etc.

The question is how do I accomplish this using VB. I am designing the form
in access 2000.

Any help, guidance, suggestions or comments will be very appreciate.

Thank you in advance for your help.