I have 2 list boxes: lstMake & lstModel
lstCatagory is populated from a query, qryMake
Lets say that in this query/list box I have selections of: Ford, Chevy, and Dodge. If I choose Ford in lstMake I want only Ford models to appear in the second list box (lstModel). I have other queries set up to do this already, Ex: qryFord, qryChevy, etc.
The question is, how to populate lstModel with the appropriate query based upon the choosen selection in lstMake.
lstCatagory is populated from a query, qryMake
Lets say that in this query/list box I have selections of: Ford, Chevy, and Dodge. If I choose Ford in lstMake I want only Ford models to appear in the second list box (lstModel). I have other queries set up to do this already, Ex: qryFord, qryChevy, etc.
The question is, how to populate lstModel with the appropriate query based upon the choosen selection in lstMake.