using subreport data in a report

[deltauser2006]

I am trying to combine two numbers created in two different subreports
within a main report for a calculation. For some reason I can not the
to show up. I was told that using putting:
[Reports]![YourSubreportName].[YourFieldonSubreport] in a text box in
the main report would pull the numbers (seperately obviously) but it
doesn't work. All I get is the "Name?#" error. Does anyone have any
ideas of why this won't work or something different I could try to
accomplish the same end? Thanks

 

[Armen Stein]

I am trying to combine two numbers created in two different subreports
within a main report for a calculation. For some reason I can not the
to show up. I was told that using putting:
[Reports]![YourSubreportName].[YourFieldonSubreport] in a text box in
the main report would pull the numbers (seperately obviously) but it
doesn't work. All I get is the "Name?#" error. Does anyone have any
ideas of why this won't work or something different I could try to
accomplish the same end? Thanks

The syntax is Reports![YourMainFormName].[YourSubformControlName].Form.
[YourFieldOnSubreport]

Note that the YourSubformControlName isn't necessarily the same as the
name of your subform database object. It's the name of the control on
your main form that contains the subform.

 

[deltauser2006]

Thanks! You're the man! That solved all my problems.

I am trying to combine two numbers created in two different subreports
within a main report for a calculation. For some reason I can not the
to show up. I was told that using putting:
[Reports]![YourSubreportName].[YourFieldonSubreport] in a text box in
the main report would pull the numbers (seperately obviously) but it
doesn't work. All I get is the "Name?#" error. Does anyone have any
ideas of why this won't work or something different I could try to
accomplish the same end? Thanks

The syntax is Reports![YourMainFormName].[YourSubformControlName].Form.
[YourFieldOnSubreport]

Note that the YourSubformControlName isn't necessarily the same as the
name of your subform database object. It's the name of the control on
your main form that contains the subform.