Filter form 1

[jazminecat23]

Hi all - I have a form I'm trying to filter. Seems simple, right? Here's my code:

Private Sub Form_Load()

Me.Filter = Not VENDOR_NUM = 0
Me.FilterOn = True

End Sub

and every time, it throws me an error. "one or more operators in the filter is invalid."

*sigh*

All I want is to show the items where the vendor number is not 0. I am using the query on which this form is based elsewhere, so I would prefer not to change the query.

Can anyone help me? I would search, but it appears searching is still down.

thanks!

 

[PHV]

Me.Filter = "VENDOR_NUM<>0"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jazminecat23]

Ok, I changed it to that. after sayind duh to myself. but now, you're not going to believe this, I am getting runtime error 2021, "one or more operators in the filter expression is invalid" and it's highlighting

Me.FilterOn = True

what the? how can this be?

(banging head on nearest available solid object)

 

[PHV]

What is YOUR actual code ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jazminecat23]

Now, it is:

Private Sub Form_Load()

Me.Filter = VENDOR_NUM <> 0
[red]Me.FilterOn = True[/red]

End Sub

and it's the second line that throws the error.

 

[PHV]

Please, reread carefully my previous suggestion ...
Me.Filter = [!]"[/!]VENDOR_NUM<>0[!]"[/!]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jazminecat23]

oh man, you are SO my hero today! I can't believe I got stuck on something that doubtless is obvious, but it's been a rough week. Thank you so much for your help - the quotes there did the trick. I really appreciate it, and hope you have a great weekend.