Avatar of ARampton
Flag for United Kingdom of Great Britain and Northern Ireland

asked on 

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]![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

Avatar of undefined
Last Comment

8/22/2022 - Mon