From: Larry R Harrison Jr [larrytucaz@mindspring.com]
Sent: Tuesday, February 06, 2001 8:38 PM
To: Larry Harrison
Subject: Re: Filtering by a Yes/No Field, PopUp Form

Hi Tanya. So far I have not received any help with numeric fields, though

someone did pass along a hint about how to fix the YES/NO field.

I put a command button on the form and assigned the following visual basic

code to it under the "OnClick" event:

With Reports.MyReport

.Filter = "SomeYesNoField = True"

.FilterOn = True

End With

That fixed it. I hope that helps.

Larry

-----Original Message-----

From: Tanya Jessup [mailto:jptanya@home.com]

Sent: Wednesday, January 24, 2001 8:45 AM

To: Larry H

Subject: Re: Filtering by a Yes/No Field, PopUp Form

 

Hi Larry,

Are you using the article #Q147143, How to filter a report from a pop-up

form? I am and I'm having the same problem. I'm also having a problem with

fields that have have a number data type. I keep getting data type

mismatch. Did you find a solution?

If so could you pass it along to me? Thank you.

Tanya