quickie filter help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
-----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
Click to expand...
Hi Sam,

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

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

Luck
Jonathan
 
Back
Top