<div>
First off, I would encourage you to use a combo with options for All, Checked, UnChecked or something like that to filter Yes/No fields. 
 
Then, I would use code similar to: 

<pre><code class="code-1 nolinks" id="code-20-42827111-1">Dim varFilter as variant

varFilter = NULL
if NZ(me.cboCheckBox1, &quot;All&quot;) = &quot;No&quot; Then
 varFilter = &quot;([CheckBox1] = 0)&quot;
else if NZ(me.cboCheckBox1, &quot;All&quot;) = &quot;Yes&quot; Then
 varFilter = &quot;([CheckBox1] = -1)&quot;
end if
</code></pre>
Then, to expand on that I'd add: 

<pre><code class="code-1 nolinks" id="code-20-42827111-2">if NZ(me.cboCheckBox2, &quot;All&quot;) = &quot;No&quot; Then
 varFilter = (varFilter + &quot; AND &quot;) &amp; &quot;([CheckBox1] = 0)&quot;
else if NZ(me.cboCheckBox1, &quot;All&quot;) = &quot;Yes&quot; Then
 varFilter = (varFilter + &quot; AND &quot;) &amp; &quot;([CheckBox1] = -1)&quot;
end if
</code></pre>
The part of the code that does: 

<pre><code class="code-1 nolinks" id="code-20-42827111-3">(varFilter + &quot; AND &quot;)
</code></pre>
will return NULL if varFilter is still when that segment of code is encountered. 
 
You can then expand your filter until you are done, and at the bottom of the cmd_Filter_Click event, I use: 

<pre><code class="code-1 nolinks" id="code-20-42827111-4">If Len(varFilter &amp; &quot;&quot;) = 0 then
 me.FilterOn = false
else
 me.Filter = cstr(varFilter)
 me.FilterOn = true
endif
</code></pre>
Hope this helps
</div>

KP_SoCal

<div>
Mr. Edwards, I have been racking my brain for hours on this, and your solution looks like it will accomplish precisely what I need for my checkbox controls! Thank you!!! =) 
 
However, I tried to incorporate a comboBox control for the third if statement, but I could not get it to work. 
 

<pre><code class="code-1 nolinks" id="code-20-42827119-1">If Me.cboItem Then
 strCriteria = strCriteria &amp; &quot; AND [fldItem]=&quot; &amp; Me.cboItem
 End If
</code></pre>
 
From this third if statement, I'm attempting to apply a filter that restricts my displayed records to a specific item within my field &quot;fldItem&quot; in addition to the other filters that I've applied through the first two if statements. Any suggestions on this? Again, I really appreciate your insight on this.
</div>

<div>
TERRIFIC!!!!!!!! I salute you, and thank so much! =))
</div>

<div>
Thanks. &nbsp;Glad I could help. &nbsp; 
 
I've been doing this since the mid 90's and spend a lot of time training new Access/VBA/SQL Server developers. &nbsp;I try to curtail my solutions to what the author says he needs, unless what he thinks he needs isn't going to work at all. &nbsp;I also try to compile and test all of my solutions before posting them - no half-baked throw-outs that won't even compile.
</div>

<div>
Contributors like you are why I am a paid subscriber to this web forum. Thanks again for your help. Have a terrific weekend! =)
</div>

<div>
<div class="content wysiwyg-content">
For simplicity's sake, in my Access 2010 database form that contains a subform, let's say I have three check box controls (I actually have much more than three) that I'm using to filter records in an embedded subform. 
 
<a href="https://filedb.experts-exchange.com/incoming/2019/03_w12/1415806/Capture.PNG" target="_blank" title="screenprint (2 KB)"><img alt="screenprint" class="file-block lazyload" style="max-width: 287px;" data-src="https://filedb.experts-exchange.com/incoming/2019/03_w12/1415806/Capture.PNG" /></a> 
As you can see from my code below, when Me.chkBoxFilter1 is checked, only records for fldFilter1= True are displayed. When unchecked, all records are displayed. 
 

<pre><code class="code-1 nolinks" id="code-10-29140294-1">If IsNull(Me.chkBoxFilter1) Then
 Me.subformColorSurrogation.Form.Filter = &quot;&quot;
 Me.subformColorSurrogation.Form.FilterOn = False

Else
 Me.subformColorSurrogation.Form.Filter = &quot;[fldFilter1]=&quot; &amp; Me.chkBoxFilter1
 Me.subformColorSurrogation.Form.FilterOn = True
End If
</code></pre>
 
I'm looking for a way I can add or remove other filters through the use of my other check boxes. I know I could accomplish this through multiple ELSEIF statements, but is there a way, for instance, when clicking M.chkBoxFilter2 to TRUE, to ONLY pull TRUE records for fldFilter2 without unfiltering the restrictions placed by my other checkboxes? 
 
I hope this makes sense. I really appreciate any insight into this.
</div>
</div>

Capture.PNG

For simplicity's sake, in my Access 2010 database form that contains a subform, let's say I have three check box controls (I actually have much more than three) that I'm using to filter records in an embedded subform.



As you can see from my code below, when Me.chkBoxFilter1 is checked, only records for fldFilter1= True are displayed. When unchecked, all records are displayed.

(CODE)

I'm looking for a way I can add or remove other filters through the use of my other check boxes. I know I could accomplish this through multiple ELSEIF statements, but is there a way, for instance, when clicking M.chkBoxFilter2 to TRUE, to ONLY pull TRUE records for fldFilter2 without unfiltering the restrictions placed by my other checkboxes?

I hope this makes sense. I really appreciate any insight into this.

Creating multiple form controls to filter records in a subform...

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

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.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.