I am trying to have a text box on the main form reference a totals text box from subreport for payments.
At times the payments subreport may have no data, but it still shows the subreport and displays a total of $0.00 in those instances (which is what is needed).
I am stuck and keep getting error or name errors. I've tried the me approach, tried getting the value in the expression builder by selecting the report at the top of the left pane, then going down to the payments subreport field and selecting the PaymentTotal field, the IIF suggested by Microsoft, various formulas referenced in other forums, etc., etc., etc.
Main report name = r_Main
Subreport: Source object from Data tab: Report.r_Main_D_Payments_sub Name from Other tab: r_Main_D_Payments_sub
Filed name from subreport that is needed on main report: PaymentTotal (the name of this text box on the main report is text12 - haven't bothered to rename it yet)
If anyone can help, I'd be grateful.
At times the payments subreport may have no data, but it still shows the subreport and displays a total of $0.00 in those instances (which is what is needed).
I am stuck and keep getting error or name errors. I've tried the me approach, tried getting the value in the expression builder by selecting the report at the top of the left pane, then going down to the payments subreport field and selecting the PaymentTotal field, the IIF suggested by Microsoft, various formulas referenced in other forums, etc., etc., etc.
Main report name = r_Main
Subreport: Source object from Data tab: Report.r_Main_D_Payments_sub Name from Other tab: r_Main_D_Payments_sub
Filed name from subreport that is needed on main report: PaymentTotal (the name of this text box on the main report is text12 - haven't bothered to rename it yet)
If anyone can help, I'd be grateful.