wherecondition value

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

Guest

I now how to pass the wherecondition value to a report using
docmd.openreport, how do you retrieve that value from within the code of the
report once it is open.
I want to retrive the value so that I can add it to the report title.

I was using the OpenArgs available within Access 2003, but I have to rebuild
for a user running Access 2000 where the OpenArgs is not available.
 
You can reference the where clause in the report by referencing the Report's
Filter property.
Try create a text box in your report with a control source of:
=[Filter]
 

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

Access OpenArgs in Access 2010 failing 0
HELP PLEASE 7
How to get value of OpenArgs in report? 1
Report using union query 2
WHERECondition in a report. 1
Access Open Form with WhereCondition 6
OpenReport & OpenArgs 2
multiple openargs 1

Back
Top