Multiple Cascading Combos ???

[Muzicmn]

ok guys,

I have searched and found lots of discussion on cascading combos but cannot find anything on multiple boxes

The situation: Company sells warranty policies for cars. I am trying to use these boxes to narrow down the search in this order:

Make, model, Mileage, and finally Pricing

So far made the cascading combos from Make to model work but using the following code in RowSource

cboMake:
SELECT DISTINCT tblMAKE.makeid, tblMAKE.make FROM qryMAKE;

cboModel:
SELECT DISTINCTROW tblmodel.modelid, tblmodel.model, tblmodel.code FROM tblModel WHERE (((tblModel.Makeid) Like forms!form1!CboMake));

now, when i try to use cboMileage or cboPricing using the same format as cboModel, i get blank data

any input would be greatly appreciated

thanks in advance

Rich

 

[Johny]

Have ya got somethin like this?

cboMake:
SELECT DISTINCT tblMAKE.makeid, tblMAKE.make FROM qryMAKE;

cboModel:
SELECT DISTINCTROW tblmodel.modelid, tblmodel.model, tblmodel.code,tblmodel FROM tblModel WHERE (tblModel.Makeid=CboMake);

cboMileage:
SELECT Mileageid, Modelid, .... FROM tblMileage WHERE (Modelid = cboModel)

cboPricing:
SELECT Pricingid, Mileageid, .... FROM tblPricing WHERE (Mileageid = cboMileage)

Each listbox should return their id as value and requery the next listbox after each after_update event.

 

[Muzicmn]

a little different phrasing, gonna give it a try and will let you know how it goes

thanks for such a quick response

Rich

 

[Muzicmn]

not sure what i am doing wrong here, i eliminated the mileage combo box in order to simplify things a bit and zipped a copy

if you dont mind taking a look and let me know what i have done wrong

thanks again

Rich

 

[Muzicmn]

just a small bump

anyone??

 

[Johny]

The 3 cascading combos work like they should be now but I don't know what you want to show on the form.

 

[Mile-O]

If you want to do cascading combos properly for multiple types then I'm assuming you have separate tables for the different things: Make, model, Mileage, and Pricing.

tblMakes
MakeID
Make

tblModels
ModelID
Model
MakeID

tblMileages
MileageID
Mileage
ModelID

tblPricing
PricingID
Pricing
MileageID

Then, you simply do the first cascade based on the first two tables, then the next cascade for mileage references the model, and then the pricing references the mileage. You just keep doing the same thing but drop one level.

 

[Daxton A.]

How's it goin Muzicmn, I got a question for ya.

Once i put the make in, the model worked where it would show me what to choose from but when i selected it, all it would show was a blank? And I am guessing that once i select the model, that other combobox will let me choose which Price right?