I have a status ComboBox list [ViewStatus] on my form [MainForm] header which I use to restrict the records showing on this form's detail section
The Form is based on a query with Status criteria = [Forms]![MainForm]![ViewStatus]
This works well with exact matches but I also want [ViewStatus] to allow showing "All" records
|What is the easiest way of writing this criteria to show all records when requested?
Criteria Like "*" usually works but I can't find a way of translating All to anything that works