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
Who is Participating?
rockiroadsConnect With a Mentor Commented:
Using * should work. Looks like you need the IIF check to determine the selection


Criteria LIKE IIF( [Forms]![MainForm]![ViewStatus] = "All", "*",  [Forms]![MainForm]![ViewStatus])
ARamptonAuthor Commented:
Fantastic, almost got there but had Like in front of my * instead of in front of my Iif...

Great quick response
no worries :)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.