Hi

What I have here is probably a syntax problem, but as usual I can't find a solution looking through the help or ms website

I'm trying to apply a filter on a report from VB

I define the string I want as a filter and then pass it to the Me.Filter, and it works fine when I have one parameter, ex. my string i
myFilter = "myNumber = '1'
I'm trying to filter on two parameters, but I don't know how to tell Access, it always gives me a "operator absent" message

Thanks for the help.

>-----Original Message-----
>Hi,
>
>What I have here is probably a syntax problem, but as
usual I can't find a solution looking through the help or
ms website.
>
>I'm trying to apply a filter on a report from VB.
>
>I define the string I want as a filter and then pass it
to the Me.Filter, and it works fine when I have one
parameter, ex. my string is
>myFilter = "myNumber = '1'"
>I'm trying to filter on two parameters, but I don't know
how to tell Access, it always gives me a "operator absent"
message.
>
>Thanks for the help.
>.
>

Wow, I'm having finger problems today. Sorry for double
post:

Me.Filter = "Number=1 AND Answer='Right Answer'"

Keep in mind, that numbers are not enclosed in quotes, but
strings are. Dates are enclosed in #'s.

Chris Nebinger


>-----Original Message-----
>Hi,
>
>What I have here is probably a syntax problem, but as
usual I can't find a solution looking through the help or
ms website.
>
>I'm trying to apply a filter on a report from VB.
>
>I define the string I want as a filter and then pass it
to the Me.Filter, and it works fine when I have one
parameter, ex. my string is
>myFilter = "myNumber = '1'"
>I'm trying to filter on two parameters, but I don't know
how to tell Access, it always gives me a "operator absent"
message.
>
>Thanks for the help.
>.
>