VBA Filter Form

[johnbird1988]

Hello

I am having trouble with the below Code

Me.Filter = "[Vacancy Status] <> '" & "Vacancy Closed"
Me.FilterOn = True
Me.Vacstatus.Value = ""

I would like to filter the Vacancy Status with any think not equal to "Vacancy Closed" or is null.

I am having error messages in the above and can figure out why can any one help please.

Thank you

John

 

[Norie]

Try this.

"[Vacancy Status]<>'Vacancy Closed'"

In the original code the criteria would have been something like this:

[Vacancy Statuse]<>Vacancy Closed

ie no quotes around 'Vacanct Closed'.

 

[johnbird1988]

That great works fine. How do i add in the "is null". i need blanks to also be returned.

Thanks

John

 

[Norie]

John

Off the top of my head it should be this.

Me.Filter = "[Vacancy Status] <> 'Vacancy Closed' Or [Vacancy Status] Is Null"

Best way to check anything like this is to try it in a query.

 

[johnbird1988]

That is correct thank you for your help