filter in access vba

I have a filter to filter on [body type] of "estate" but cannot get the syntax right to filter on "estate" and "MPV"

Me.Form.Filter = "[Body type]=" & """" & "Estate" & """"
PeterBaileyUkAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
IrogSintaConnect With a Mentor Commented:
Did you mean you wanted to show records where body type was either Estate or MPV?
If so, try this:

Me.Form.Filter = "[Body type]='Estate' Or [body type]='MPV'"
0
 
PeterBaileyUkAuthor Commented:
thank you and HNY
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.