By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,486 Members | 1,749 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,486 IT Pros & Developers. It's quick & easy.

Problem pulling value of OpenArgs into report InputParameters

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

Where is the data entered already? On an open form? If so, just
reference the form...

e.g.

DoCmd.OpenReport rptMyReport, MyField=Forms!MyForm!MyField

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.