I have a form that has an unbound combo box that retreives all the filtered data from the choice I made then I click the report button and all works well. Problem, I need a second combo box that I can use on the same form to choose by date (within last 30 days, 90 days, etc.) that would then filter even more. I’m new to VBA so be kind. How can I filter those different date ranges in the same combo box or on the same query? I can put in the criteria field Between (Now()-30) And Now() and this works but not for 90 or 180 days.
