<div>
You can't use OR with &lt;&gt;<br />
Try to change OR to AND<br />
<br />
For example A &lt;&gt;&nbsp;2 OR A &lt;&gt;&nbsp;1 will always be true
</div>


<div>
<div class="content wysiwyg-content">
I have this filter :<br />
Me.Form.Filter = &quot;[Body type]&lt;&gt;'Estate' OR [body type]&lt;&gt;'MPV' OR [body type]&lt;&gt;'Hatchback' Or [body type]&lt;&gt;'Saloon' Or [body type]&lt;&gt;'Roadster'&quot;<br />
<br />
The syntax appears ok however i get records showing within the exclusions.<br />
<br />
if i do this Me.Form.Filter = &quot;[Body type]&lt;&gt;'Estate' it will exclude the group.
</div>
</div>


I have this filter :
Me.Form.Filter = "[Body type]<>'Estate' OR [body type]<>'MPV' OR [body type]<>'Hatchback' Or [body type]<>'Saloon' Or [body type]<>'Roadster'"

The syntax appears ok however i get records showing within the exclusions.

if i do this Me.Form.Filter = "[Body type]<>'Estate' it will exclude the group.

vba filter not working on OR

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.