<div>
Fantastic, almost got there but had Like in front of my * instead of in front of my Iif...<br />
<br />
Great quick response
</div>


<div>
<div class="content wysiwyg-content">
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<br />
<br />
The Form is based on a query with Status criteria &nbsp;= [Forms]![MainForm]![ViewSt<wbr />atus]<br />
<br />
This works well with exact matches but I also want [ViewStatus] to allow showing &nbsp;&quot;All&quot; records<br />
<br />
|What is the easiest way of writing this criteria to show all records when requested?<br />
<br />
Criteria Like &quot;*&quot; usually works but I can't find a way of translating All to anything that works
</div>
</div>


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

Showing all records on a Query whose criteria is from a form ComboBox List item &quot;All&quot;

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

Showing all records on a Query whose criteria is from a form ComboBox List item &quot;All&quot;

Showing all records on a Query whose criteria is from a form ComboBox List item "All"