Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

OpenArgs in OpenReport()

1 view
Skip to first unread message

Harry

unread,
Oct 14, 2003, 3:14:00 PM10/14/03
to
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

unread,
Oct 14, 2003, 6:21:33 PM10/14/03
to
Harry wrote:

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.

--
Marsh
MVP [MS Access]

0 new messages