Please help with second filter

D

Dirtbike

I need a second filter or a filter with 2 criteria. I've tried
DoCmd.ApplyFilter "", "[TagToDo]![ServOpen]=True" And
"[TagToDo]![ServClosed]=False" with no luck.
 
K

Klatuu

Your syntax just needs adjusting. The And needs to be inside the quotes.
Also, I would suggest you not use the ApplyFilter method. A better technique
is:
Me.Filter = "[TagToDo]![ServOpen]= " & True & " And " &
"[TagToDo]![ServClosed]= " & False
Me.FilterOn = True
 
Top