Hi All



Hope someone can help me using Access 2007:

I am trying to find some simple instructions on how to us Cascading Combo Boxes to filter a query. The query contains the customer name, product name, price etc. and date delivered (mm/yyyy)

I want to be able to filter this query to produce a report using 2 cascading combo boxes, 1st being the company name and the 2nd being the date delivered. Also, I don't want the date delivered combo box to show duplicate dates (i.e if company 'A' has more that one record with 'May2009', the date combo box will only show 'May2009' once)

If someone can give me some instruction from start to finish with this I would be more than grateful. I am at the planning stage at the moment so nothing i have done is set in stone

Thanks in advance