Access cascading combo box help :)

[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

 

[kjv1611]

Easiest way is to create a query for your 2nd combo box, and in that query, add a condition under your ForeignKey that says something like:
Forms![MyFormName]![ControlBoxMake]

If you have Office 2010, as you start typing that condition in, it'll give you an autofill drop-down which is NICE NICE NICE... helps to avoid typos.


"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

 

[sjanssen]

thank you so much! this did the job!

 

[kjv1611]

glad it worked out.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57