Filter a Report from a Pop-Up Form 1

[BILL62]

I am trying to Filter a Report from a Pop-Up Form. The code is listed on Microsoft.com as ACC2000,(Q208529). When I apply the code to my database, I get a compile error on
Char 35.
Can anyone tell me how to correct this?
I have checked my VB library & Char is there.

 

[RickSpr]

Huh? There's no "Char" function in VBA. There's a "Chr" function, and it's used in the Knowledge Base article, but it's "Chr(34)" (the quote character), not "Chr(35)". Did you just do a really bad job of copying the code? Rick Sprague

 

[BILL62]

No I copied the code correctly, I just did a really bad job of typing my request for help. (I was tired)
It is Chr(34).
Anyway, I fixed the compile error last night.
Thanks for your sarcastic response.

 

[RickSpr]

You claimed to get a compile error, but gave no clue what it said. You spelled the function name wrong, omitted the parentheses, and gave the wrong argument value. Then you claimed to have "verified" that a non-existent function exists in your system. The only useful fact you provided was the Knowledge Base article number. I wasn't even sure your "Char 35" had anything to do with Microsoft's "Chr(34)" anyway.

The triple syntax error in the code as you presented it here, and the erroneous verification of the "Char" function, make it entirely reasonable that you could have done a careless job of hand-copying the code. If you had, it would certainly have caused a compile error--which is what you complained of. There wasn't anything "sarcastic" in what I said, it was a perfectly legitimate suggestion given what I could glean from your post.

On the other hand, your "Thanks for your sarcastic response" is, unequivocally, a sarcastic response. So would be "I'm sure you'll have lots of people clamoring to help you, with that attitude, fella!" Rick Sprague