Combo box by dates

[torquay]

Can someone point me in the right direction to filter reports by specific date types in a drop down or combo box
I would like the dates to be
Today
Tomorrow
The next 3 days and the next 7 days
i don't want a date picker or between dates
I have tried searching but cannot seem to find an answer
They are for my engineers, they want to know what callouts they have today or tomorrow or the next 3 days or this week.
Thanks
Kim

 

[MarkK]

What do you mean, "point you in the right direction?" Are you have trouble actually filtering the report? Are you having trouble calculating a day three days from now? Are you having trouble getting data into a combobox?

 

[torquay]

Sorry for not being a little more explicit.
I have a report with callouts for the next week show date, time customer, address and phone number
I would like to filter these using a combo box set for either todays callouts or tomorrows callouts or the next 3 days or this week call outs. I am unsure how to programme the combo box for the 3 choices
Todays callouts or
Tomorrows or
The next 3 days (today, tomorrow and the next day)
As the search is always the same I think it would be quicker to filter by combo box rather than date picker
I just dont know how to code the combo box
Thanks

 

[MarkK]

What I might do is create a combobox where the RowSourceType = "Value List" with a RowSource of . . .

1;Today;2;Tomorrow;3;Next 3 Days

Then set the Column Count property to 2, and the Column Widths property to 0";2", so that the items in the combo will be . . .

Today
Tomorrow
Next 3 Days

. . . and the number will be hidden. Then you can handle the Click or AfterUpdate events of the combo, check the value of the control to determine what was selected, and then calculate your dates and open your filtered report.

And that doesn't require any code. You can do it all in design view.