Filter form records by Date with Combo box

[jhrBanker]

I have a form based on a query. Each record in the query has a "Date Entered". Multiple records can have the same "Date Entered". How can I add a filter combo box to the form to filter the records based on the date selected in the combo box. I want the combo box to contain all of the available dates in the query, and I want all records to be displayed if no date is selected in the combo box. It would also be desireable to have the default value of the combo box be the maximum (lastest) date in the query.

I'm using Access 2007.


Form name: frmReview
Query name: qryFrmReview
Field name: Entered

[Stingaway]

Create a query that groups all of the dates in the original query (or more likely in the table), sort as preferred. Use this newly created query as your combo box source. In the On Update property of the combo box, re-filter the form. You may have to edit your original query to look at the combo box before opening and if null pull all records.

[jhrBanker]

Thanks for the response, but you really haven't answered my question. I've created the query to use a the Combo Box source, and I'm able to filter the records by the date selected in the Combo Box. What I haven't got is the option to select all records regardless of date.