Filter Syntax Question 1

[missymarie1014]

Access 2000.... Can someone tell me why this code produces a type mismatch error. Each filter, when executed separately, works fine. Am I doing something wrong in trying to combine them? These are Boolean fields.

Private Sub ActiveRawCommand_Click()
On Error GoTo Err_ActiveRawCommand_Click

    Me.Filter = "InactiveProduct = 0" And "IsBulkProduct = 0"
    Me.FilterOn = True

Exit_ActiveRawCommand_Click:
    Exit Sub

Err_ActiveRawCommand_Click:
    MsgBox Err.Description
    Resume Exit_ActiveRawCommand_Click
    
End Sub

 

[PHV]

Me.Filter = "InactiveProduct = 0 And IsBulkProduct = 0"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[missymarie1014]

Well, now I feel like an idiot! Thanks PHV. Very helpful as usual! Sometimes the simplest things are so difficult.