Filter form based on criteria from two fields

[wsneeden]

I currently have a button set up on my main form that filters results on a subform for a specific value in a combo box. No issues getting this to work. What I want to do now is add an additional requirement to the filter that will only show 'false' values in a checkbox.

My current code is:

Private Sub ReceivingFilter_Click()
Me.InspectionDetail_Subform.Form.Filter = "InspType = 'Receiving'"


Me.InspectionDetail_Subform.Form.FilterOn = True
End Sub

I've tried multiple things to add in the additional checkbox filter but nothing seems to work. Any suggestions?

[pbaldy]

It would help if you posted what you tried. Basically you need to add

And OtherField = False

inside the quotes.

[wsneeden]

I've tried adding an 'AND' statement like the one below. It returns a 3075, missing operator error. Not sure what I am missing here.

Private Sub ReceivingFilter_Click()
Me.InspectionDetail_Subform.Form.Filter = "InspType = 'Receiving' AND Complete? = 'False'"
Me.InspectionDetail_Subform.Form.FilterOn = True
End Sub

[pbaldy]

For starters, the field with the inadvisable symbol needs to be bracketed. Also, I didn't have any quotes around False.