Filter for 2 values

[Sadukar]

Hi All
I am trying to filter a form by using 2 different values.

I tried:
Me.Subform.Form.Filter = "[Interval] = '3M'" Or Me.Subform.Form.Filter = "[Interval] = '2M'"
Me.Subform.Form.FilterOn = True
Didn't Work.
I also tried using And insted of Or. Didn't Work either.

Any suggestions on how to do this?

Regards
S.

 

[DonQuichote]

Try either

Me.Subform.Form.Filter = "[Interval] = '3M' Or [Interval] = '2M'"
Me.Subform.Form.FilterOn = True

or

Me.Subform.Form.Filter = "[Interval] in ('3M','2M')"
Me.Subform.Form.FilterOn = True

The second form is somewhat better readable if you have more choices to filter on

Best regards

 

[Sadukar]

Thanks Don
Works Perfect