Showing all records on a Query whose criteria is from a form ComboBox List item "All"
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]![ViewSt
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
The Form is based on a query with Status criteria = [Forms]![MainForm]![ViewSt
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
no worries :)
ASKER
Great quick response