vba filter not working on OR

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.

PeterBaileyUk

Asked: 2013-01-06

Advertise Here

Microsoft Access

1 Solution

LVL 41

als315Commented: 2013-01-07

You can't use OR with <>
Try to change OR to AND

For example A <> 2 OR A <> 1 will always be true

LVL 29

IrogSintaCommented: 2013-01-07

As Alex said, you can change your ORs to ANDs, or you can use this:
Me.Form.Filter = "[Body type] NOT IN('Estate', 'MPV', 'Hatchback', 'Saloon', 'Roadster')"

PeterBaileyUkAuthor Commented: 2013-01-07

nice solution thx

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.

vba filter not working on OR

Join & Write a Comment Already a member? Login.

Featured Post