<div>
Simple fix. &nbsp;Makes sense now that I see it. &nbsp;Thanks for your help!
</div>


Simple fix.  Makes sense now that I see it.  Thanks for your help!

<div>
<div class="content wysiwyg-content">
Good morning!<br />
<br />
I have a combo box on a form which I am having problem with the selct query for the data.<br />
<br />
Esentially, this combo box is a look up of the records currently available to the form. &nbsp;I use a radial button to apply a filter to the form and I ask for the combox box to requery after the filter is applied, however i can't seem to format the criteria statement correctly in the select query.<br />
<br />
This is my criteria for my Employment Status field in the Select Query of the combo box.<br />
<br />
<br />
IIf([Forms]![Employee Details]![RBtn_Show_Inacti<wbr />ve]=False,<wbr />&quot;active&quot;,)<wbr /><br />
<br />
When the button is false (or filtered), only records with &quot;active&quot; are selected, however when I remove the filter, I want all records to show. &nbsp;Using the statement above, no records are selected. &nbsp;<br />
<br />
I've also tried to format the False part of the IIF statement with options like &quot;*&quot;, &quot;Active&quot; AND &quot;Inactive&quot;, Not Null...nothing seems to return all the records. &nbsp;I can ask for another criteria such has &quot;Inactive&quot; and it will select those records so I know the IFF statement is correct.<br />
<br />
What am I doing wrong?
</div>
</div>


Good morning!

I have a combo box on a form which I am having problem with the selct query for the data.

Esentially, this combo box is a look up of the records currently available to the form.  I use a radial button to apply a filter to the form and I ask for the combox box to requery after the filter is applied, however i can't seem to format the criteria statement correctly in the select query.

This is my criteria for my Employment Status field in the Select Query of the combo box.


IIf([Forms]![Employee Details]![RBtn_Show_Inactive]=False,"active",)

When the button is false (or filtered), only records with "active" are selected, however when I remove the filter, I want all records to show.  Using the statement above, no records are selected.  

I've also tried to format the False part of the IIF statement with options like "*", "Active" AND "Inactive", Not Null...nothing seems to return all the records.  I can ask for another criteria such has "Inactive" and it will select those records so I know the IFF statement is correct.

What am I doing wrong?

Applying a select query for a combo box with criteria from a form.

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.