Please help with second filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top