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?
 
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
All Courses

From novice to tech pro — start learning today.