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


B

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?
 
Ad

Advertisements

A

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]
 
B

bobbymo25 via AccessMonster.com

Arvin said:
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]
[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?
 
A

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

bobbymo25 via AccessMonster.com said:
Arvin said:
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]
[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?
 
B

bobbymo25 via AccessMonster.com

Arvin said:
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..........
 
Ad

Advertisements

N

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)

Arvin said:
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..........
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top