Hi, I've created a couple of comboBoxes which act as filters to a table I'm viewing on a Form.
I would like to show all records if possible but can't seem to figure out/or find an answer

I am filtering by name and week number but I would like the option to show all records using a selection from the combobox

I found these to tutorials but can't seem to amend them to my problem.

http://www.tutcity.com/view/leaving-a-combo-box-blank.6340.html

http://support.microsoft.com/kb/128881

---

Reply from Richard Rost:

The best solution I have found if you want to include an "ALL RECORDS" option is to add a little check box next to the combo box which the user can check on or off saying "yes, please use this combo box as a criteria." Then, in the AfterUpdate events for the combo boxes and check boxes, you can use the DYNAMIC SQL technique that I teach in Access 311 to manually update the recordsource for the form.