filtered cascading combo boxes

[tonycl69]

Hi, I know there has been many threads written around cascading combo boxes, but I can't seem to figure out if any of them fit my problem.
I have a continuous form. in the header I have 3 combo boxes based on 3 tables of single firlds, each one filters the form i.e location, category and status. But when I filter a category I can't then filter in that category a location, the location combo just filters the location and ignores the category etc. What I would like is to still be able to filter from each combo box but also narrow each combo like a cascading combo box set if you get my drift.

 

[tonycl69]

Thanks for your reply, this is fine if I were using a single form scenario, but I am using a continuous form. I have 3 combo boxes based on 3 tables which are just lists that feed a main table, I have a qry behind the continuous form, each combo box filters 3 different columns succesfully but I need to drill down instead of just filter 3 columns. Can you help with this please.

 

[tonycl69]

Thank you for your help, I don't seem to have explained myself very well, my fault. I have a continuous form that shows all records in a vehicle maintenance db. I have 3 combo boxes that filter 3 fields, location, category and status. They have there source from 3 tables with just a list of location, category and status. These are in the form header. But the problem is when I select any combo box to filter the main form it works fine but as soon as I select one of the other combo boxes to filter I lose the filter of the previous filter, thus I need to have cascading lists to drill down if I need to but still filter on any of the 3, so if I choose category I need the other 2 to only have location and status relative to category and any combination of the 3. Is this at all possible or is there perhaps an alternative method. All help appreciated.