OpenArgs in OpenReport()

  • Thread starter Thread starter Harry
  • Start date Start date
H

Harry

Hi all, when I using Access 2002, the openreport takes in
an OpenArgs as below:

expression.OpenReport(ReportName, View, FilterName,
WhereCondition, WindowMode, OpenArgs)

However, when I tried this on Access 2000, the error msg
say wrong number of parameters. From the VBA help, it
appears that it does not accept the last parameter. Any
way to get around this problem?

Thanks in advance.
 
Harry said:
Hi all, when I using Access 2002, the openreport takes in
an OpenArgs as below:

expression.OpenReport(ReportName, View, FilterName,
WhereCondition, WindowMode, OpenArgs)

However, when I tried this on Access 2000, the error msg
say wrong number of parameters. From the VBA help, it
appears that it does not accept the last parameter. Any
way to get around this problem?
Click to expand...

OpenArgs for reports is new in A2002. You'll have to use
one of the older techniques. The form that initiates the
report should park the value in a form textbox or a standard
module, module level, Public variable. Then the report can
retrieve the value from the publicly available location.
 
Back
Top