I am using A2007 and A2003. My question involves filtering with VBA . After filtering, I want to button click to add one more filter. I use this:
Me.Filter = Me.Filter & " AND SERIES= """ & Me.AddOnBox & """"
It works if the first filter is for only one possible value. If the first filter includes more than one possible value (Me.Filter = "LastName = """ & Me.Filt1Box & """" & " OR LastName = """ & Me.filt2Box & """"), nothing filters.
How do I make the AND functional with a multiple choice pre filter?. Any help much appreciated.