Total sum in textbox of report footer and displayed in textbox on a subform

[bobbymo25]

Hi,

I have created a report to calculate the total number of hours worded by
staff. I have made the textbox on the report which displays the total (works
fine). However i want a textbox on my subform to read the total in the
textbox on the report.

i have used this expression:

=[Reports]![TN1_CIO_RawData]![Text15]

Once i run my subform it displays the message: #Name?

Can anyone please help me? On how i would be able transfer the result of the
textbox from the report to the textbox on the subform?

 

[Arvin Meyer [MVP]]

I expect that you mean subreport, not subform. A form cannot read data from
a report (although a report can read data from a form). For a subreport, the
expression would be:

=[Reports]![TN1_CIO_RawData].[Report]![Text15]

 

[bobbymo25 via AccessMonster.com]

I expect that you mean subreport, not subform. A form cannot read data from
a report (although a report can read data from a form). For a subreport, the
expression would be:

=[Reports]![TN1_CIO_RawData].[Report]![Text15]

Hi,

[quoted text clipped - 13 lines]

the
textbox from the report to the textbox on the subform?

Thanks for the info. However i generated the report from the from in order
to record the total sum. Now i would like the total sum on the report to
show on the form. Is there a way of doing this?

 

[Arvin Meyer [MVP]]

Do the same thing on the form.

=[Forms]![NameOfSubformControl].[Form]![TextBoxName]

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

I expect that you mean subreport, not subform. A form cannot read data
from
a report (although a report can read data from a form). For a subreport,
the
expression would be:

=[Reports]![TN1_CIO_RawData].[Report]![Text15]

Hi,

[quoted text clipped - 13 lines]

the
textbox from the report to the textbox on the subform?

Thanks for the info. However i generated the report from the from in
order
to record the total sum. Now i would like the total sum on the report to
show on the form. Is there a way of doing this?

 

[bobbymo25 via AccessMonster.com]

Do the same thing on the form.

=[Forms]![NameOfSubformControl].[Form]![TextBoxName]
[quoted text clipped - 13 lines]

to record the total sum. Now i would like the total sum on the report to
show on the form. Is there a way of doing this?

No that didn't work either..........

 

[Naeem Azizian]

if you want the value to appear when you close the report:
1- open the report
2- open the report properties
3- go to events section of the properties page.
4- choose On Close event.
5- click on the ... and choose Code Builder
6- type [Forms]![NameOfSubformControl].[Form]![TextBoxName] =
me.control (of your report)

Do the same thing on the form.

=[Forms]![NameOfSubformControl].[Form]![TextBoxName]

I expect that you mean subreport, not subform. A form cannot read data
from

[quoted text clipped - 13 lines]

to record the total sum. Now i would like the total sum on the report to
show on the form. Is there a way of doing this?

No that didn't work either..........