RESetting Input Parameters on Access Report

  • Thread starter Thread starter Dina
  • Start date Start date
D

Dina

Hi All.
I have a report in Access that has it's input parameters set to supply a
stored procedure a particular number coming from a text box on a particular
form.

Example:
Input Parameters @OrderID = [Forms]![frmTEST]![txttest]

On a completely separate form I want to call a Macro that prints out this
same report. But I need to REset the input parameters. How do I do that in
code?

I have:
Report_rptReportName.InputParameters. = txt1.text

The error is runtime error 424- object required.

Any help?
Thanx

D
 
hello,

With this statement:
Report_rptReportName.InputParameters. = txt1.text

Having . after inputparameters tells VB to look for an
object. That's why you are getting the Object Required
error.
 
thanx bussy. i wish it were so simple though. My typing the "." was in
error. In my actual code there is no ".". Any other suggestions?

me said:
hello,

With this statement:
Report_rptReportName.InputParameters. = txt1.text

Having . after inputparameters tells VB to look for an
object. That's why you are getting the Object Required
error.

-----Original Message-----
Hi All.
I have a report in Access that has it's input parameters set to supply a
stored procedure a particular number coming from a text box on a particular
form.

Example:
Input Parameters @OrderID = [Forms]![frmTEST]![txttest]

On a completely separate form I want to call a Macro that prints out this
same report. But I need to REset the input parameters. How do I do that in
code?

I have:
Report_rptReportName.InputParameters. = txt1.text

The error is runtime error 424- object required.

Any help?
Thanx

D


.
Click to expand...
Click to expand...
 
Back
Top