OpenReport Method

E

Eric D.

Hi,

Is there a way to access the wherecondition parameter from the OpenReport
method?

TIA,
Eric
 
M

Marshall Barton

Eric said:
Is there a way to access the wherecondition parameter from the OpenReport
method?
Click to expand...


Now that is a confusing question. ;-)
You specify the WhereCondition argument on the OpenReport
method.

Maybe you meant the report's Open event procedure?? If so,
the Report's Filter property is supposed to contain the
argument string.
 
E

Eric D.

That's not what I mean. Let's say I run a report like so:

DoCmd.OpenReport "report_name", acPreview,,"wherecondition"

When the report is running the OnOpen event, I want to see what the value of
that wherecondition was. How do I do that? I tried doing Me.Filter and
Me.ServerFilter, but these give me an empty string.

TIA,
Eric
 
M

Marshall Barton

Maybe it's different in an adp, but, as I said, I expect to
find the wherecondition string in the Filter property, at
least in an mdb. I don't think there is another way to get
to it.

If that's not happening for you, try placing a copy of
wherecondition in a hidden text box on the form so the
report can retrieve it from there. Alternatively, you could
use OpenArgs to pass a copy of wherecondition.
 
Top