Combo box help to display only certain days

[tomj]

I want to create a combo box that will display items based on day of the week. I have a table listing individual items and a specific day of the week they are made. My order form has a ORDER_DATE and I want the combo box to only display items made up to 2 days from that date. To complicate this, orders can be place on Friday and Saturday so the combo box would have to display items for SAT-MON for the Friday date and MON-TUE for the Saturday date. Any help appreicated!

 

[llkhoutx]

The row source for your combobox should be a query, with the date field having a criteria which filters as you want.