Filter forms

[prabhus]

While applying filter in forms, i have 6 fields in the form and i want to display the data even one of the filed is with 0.
I used the below code, but this one display the data where all the fileds are 0. I tried or in place of and but still its not working.

Private Sub Form_Open(Cancel As Integer)
Me.Filter = "[Placed]=0 and [receievd]=0 and [Ordered]=0 and [processed]=0 and [delivered]=0 and [closed]=0"
Me.FilterOn = True
End Sub

 

[Uncle Gizmo]

Try changing the and to or

 

[prabhus]

It worked, but is it possible to have AND & OR in same filter like below.

Private Sub Form_Open(Cancel As Integer)
Me.Filter = " ¨[Customer1]=-1 and [Active]=0 and [Placed]=0 or [receievd]=0 or [Ordered]=0 or [processed]=0 or [delivered]=0 or [closed]=0"
Me.FilterOn = True
End Sub