use a listbox and date range filter together

[shazbot]

Iam setting up a form that will open a report based on a query. I would like to set up a filter on the report using a list box to select one item from the list and then use date range criteria that the user will enter. For example, a report on customers who bought a certain product during a certain period of time. The user would select the product from a listbox and then enter the date range and open the report from a command button on the form. I am using code from Allan Browne that I found on the web for the date range part which is current ly working fine but I dont know how to incorporate the listbox criteria. I am a novice with Access and any coding that goes along with it, as you may have already guessed. Thank you.

 

[MajP]

Can you post the working code?
Name of the form with the listbox?
Name of the listbox?
and the table names and fields like:

tblDates
productID
startDate
endDate
....

 

[FancyPrairie]

Check out this FAQ faq181-5497. It will allow you to do what you want. Simply open a new module and copy the code from the FAQ and paste it into your new module. Then follow the directions in the Header of the FAQ. Basically, you use the Tag property of the list box and textboxes (date range) to make it work.