Passing a variable to the Report

[DanKay1]

Is it possible to assign a textbox/label inside report that will get a variable assigned to it.

Ex. I am trying to run a function that will calculate results and I want to open Report and show that result.

Thank you.

 

[jaydeebe]

Just set the control source of your text box to be the function, i think.

 

[DanKay1]

No that wont work because i am calling that function from somewhere else.

 

[jaydeebe]

what do you mean by "somewhere else" and what is the function?

 

[DanKay1]

Private Sub Add(x,y)
z=x+y
docmd.openreport Addition
Report_Addition.labelName=z
end sub

it doesn't pass the variable to that report.

 

[Zygor]

Have you tried passing it to the tag property or as the openargs?

 

[flyover789]

Dan,

- open the report in designview, hidden
- change the value (or caption, if the diplay field is a label) to your variable
- close the report, saveyes
- reopen the report (normal, preview, what you like)

HTH,
fly

[blue]Typos, that don't affect the functionality of code, will not be corrected.[/blue]

Martin Serra Jr.

http://www.mserrasystems.com