Passing subreport text box value to main report

[TB11]

Hi. I keep getting errors when I try to pass the value of a text box on a subreport to the main report. (I'll need this value on another subreport.)

Main report is: r_Main

Control source of subreport is: Report.r_Main_subA

Text box on subreport is: TotalCosts

Can anyone help?

Thanks.

 

[theDBguy]

Have you tried something like?

=[SubReportControlName].Report.[TotalCosts]

 

[TB11]

@theDBguy No luck. I get #Name?

 

[theDBguy]

@theDBguy No luck. I get #Name?

#Name? means a typo. Make sure you spell the names of your objects correctly.

 

[TB11]

@theDBguy I checked for typos, I've copied the subform control and the text box name from the property sheets. I've also tried the expression builder, but I still get #Error

 

[theDBguy]

@theDBguy I checked for typos, I've copied the subform control and the text box name from the property sheets. I've also tried the expression builder, but I still get #Error

Can you post some screenshots showing the Properties of your controls? Since we cannot see what you're doing, you'll have to show it to us.

 

[TB11]

@theDBguy thanks. I'm going to try on a simpler report. Maybe there is an issue with the report design

 

[theDBguy]

@theDBguy thanks. I'm going to try on a simpler report. Maybe there is an issue with the report design

Sounds good. Let us know how it goes. Good luck!

 

[Gasman]

Have you actually used that Report prefix?