Applying Filter from VBA that will filter on more than one control criteria

[bhujanga]

I have a form in whcih I'm putting several command buttons to use to make various commonly desireable filters.
I use the Docmd.ApplyFilter command to acheive this.
It works fine as long as I want only one control to define the filter. I can't seem to find syntax that allows you to string two or more filter criteria together, and if I use to separate commands the second one automatically nullifies the first one before it takes effect. Is there a syntax ot better method to do this?

 

[PHV]

Use the AND operator when building the ConditionWhere named parameter of the ApplyFilter method.

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