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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I view a reports Recordset 6
WHERECondition in a report. 1
long-time report fails intermittently under Access 2007 SP2 5
OpenArgs in OpenReport() 1
Cancel = True - error 2
access open report where condition 1
Problem With Where Condition in OpenReport 1
Report won't open - in either view or design mode 3

Back
Top