Access cascading combo box....help please :)

[sjanssen]

I have a form with which I'm trying to create a cascading combo box. The form will contain two drop down boxes, one for vehicle make and one for vehicle model. I would like to be able to set the model to be contingent upon the make. For example, if I pull down Toyota, I only want to see Camry, Corolla, Tercel etc. So far, I have created the make table (vehmake) to include the following columns, makeid (primary key), Code (TOYT), Make (Toyota). I have created the model table, (vehmodel) to include modelid (primary key), Code (COR), Model (Corolla), and Makeid (foreign key). I have created the join, and the vehmake table allows me to view all models under each make. However, when I put the controls on the form, I can't get the models to reflect the current make I've selected. Is there a query I need to develop?? Any help would be so very appreciated. I'm an access newbie

 

[SkipVought]

hi,

You'll get better results for MS Access questions in one of the many MS Access formus like forum702

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Andrzejek]

Would that work for you?

Have fun.

---- Andy

 

[SkipVought]

Gaaaaahhhly Sargent Caarter!

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]