Use checkbox to filter data

[acm007]

Hi, please see picture below:



I want to write a VBA code so I when the checkbox or button (both at the top of the screen) is checked, it does not show the items that are "Canceled" or "Received" in the Status column.

Items names:
1) status search box is called "S_Status"
2) status dropdown menu is called "Status"
3) the dropdown option is pulled from Query "N_Q_PlacingOrders_Status" which pulls from Table "N_T_Placing Orders_Status".

I am not too experienced with VBA, so if you can please help me write this code, I would really appreciate!

[pbaldy]

With multiple optional criteria, I tend to use dynamic SQL, as demonstrated in the sample db here:

http://www.baldyweb.com/BuildSQL.htm

[acm007]

Hi,

I tried to understand it from your website, however since my knowledge is very limited I was unable to do it. I tried the following but is still not working correctly. Would you be able to help me fix it?

Private Sub CheckBox_Click()
If CheckBox = True Then
DoCmd.ApplyFilter , Status = True
If CheckBox = False Then
Exit Sub
End If
End If
End Sub

[pbaldy]

Try

If Me.CheckBoxName = True Then
  Me.Filter = "Status = True"
  Me.FilterOn = True
Else
  Me.Filter = ""
  Me.FilterOn = False
End If

[Gicu]

I thought you said you wanted to filter out Canceled and Received:

If Me.CheckBoxName = True Then
  Me.Filter = "Status <> 'Canceled' AND Status <>'Received'"
  Me.FilterOn = True
Else
  Me.Filter = ""
  Me.FilterOn = False
End If

Cheers,
Vlad

[acm007]

Thank you Pbaldy and Gicu! Yes Gicu, excluding those two options worked really well. Thank you again!