Sub report question

  • Thread starter Thread starter Darryl
  • Start date Start date
D

Darryl

Greetings,
I have report 1. I have report 2 as a subreport in the report footer of
report 1.

I also have a text box in the report footer of report 1. Can I set the
textbox (in report 1) value
from withing the subreport (report 2) ?

I have tried several things without success.

text45.text = Me.[total cases]

I've tried:
darryl1.text45.text = Me.[total cases]

I have also tried:
text45.setfocus
text45.text = Me.[total cases]

thanks for any help.

-Darryl
 
didn't seem to work.

The textbox named text45 on Report 1 needs assigned a value from the
datasource used by
report2 (which is a subreport of Report 1).

Seems to me you should be able to put code on the Print Detail (Of report 2)
that
assigns the value of [total new cases] (a field in the data source of
Report 2) to the
textbox text45.

I have been stumped on this.

Thanks,
Darryl

BTW, it complains that object doesn't support this method when trying your
approach.
jl5000 said:
Try:
=[Reports].[Report 1]![total cases]

--
jl5000
<a href="http://www.joshdev.com"></a>


Darryl said:
Greetings,
I have report 1. I have report 2 as a subreport in the report footer of
report 1.

I also have a text box in the report footer of report 1. Can I set the
textbox (in report 1) value
from withing the subreport (report 2) ?

I have tried several things without success.

text45.text = Me.[total cases]

I've tried:
darryl1.text45.text = Me.[total cases]

I have also tried:
text45.setfocus
text45.text = Me.[total cases]

thanks for any help.

-Darryl
Click to expand...
Click to expand...
 
Back
Top