jazminecat23
Programmer
Hi all - I have a form I'm trying to filter. Seems simple, right? Here's my code:
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!
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!