Hello:
I am using an Access 2003 project as a front-end to a SQL Server 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