quickie filter help

[smk23]

I have the following line of code for a form filter:

Me.Filter = "NoteStatus <> 2802" Or "Is Null"

but my syntax is not correct
can anybody straighten me out?
Thanks so much

 

[Jonathan Parminter]

-----Original Message-----
I have the following line of code for a form filter:

Me.Filter = "NoteStatus <> 2802" Or "Is Null"

but my syntax is not correct
can anybody straighten me out?
Thanks so much

Hi Sam,

assuming that NoteStatus is a field name or control name
then:

Me.Filter = "[NoteStatus] <> 2802 Or [NoteStatus] Is Null"

Luck
Jonathan