OpenReport Method

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

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

TIA,
Eric
 
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.
 
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
 
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.
 
Back
Top