<div>
<div class="content wysiwyg-content">
I have a filter to filter on [body type] of &quot;estate&quot; but cannot get the syntax right to filter on &quot;estate&quot; and &quot;MPV&quot;<br />
<br />
Me.Form.Filter = &quot;[Body type]=&quot; &amp;&nbsp;&quot;&quot;&quot;&quot; &amp;&nbsp;&quot;Estate&quot; &amp;&nbsp;&quot;&quot;&quot;&quot;
</div>
</div>


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" & """"

filter in access vba

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.