OpenArgs in OpenReport()

[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.

 

[Marshall Barton]

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?

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.