How to get value of OpenArgs in report?

[Neil]

Hello:

I am using Access 2003 as a front-end for a database in an SQLServer
2000 database.

When I am calling a report, I use this line in the VBA code:

DoCmd.OpenReport "rptBilling_Details_Specific", acViewPreview, , ,
acWindowNormal, intBillId

intBillId is an integer value that I want to pass into the report
in the OpenArgs parameter.

In the report code, I set the InputParameters property to:
@billId int =
[Reports]![rptBilling_Details_Specific]![OpenArgs].[Value]

When I launch the report, I get a popup asking for the value of
[Reports]![rptBilling_Details_Specific]![OpenArgs].[Value]

If I enter it, everything works fine, but I want it to automatically
pull the value from the OpenArgs parameter instead of asking the
user for it.

Any ideas what is wrong?

Thanks,
Neil

 

[Pat Hartman\(MVP\)]

Use Me.OpenArgs to refer to the property from within the report.