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
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