link textbox to another textbox

  • Thread starter Thread starter Harold Good
  • Start date Start date
H

Harold Good

Hi,

In a report, I have a Textbox1 in the Group Footer with Control source
=Count(*) and Running Sum "No".

Since this is at the bottom of the report, I would like to display the
result in Textbox2 at the top of my report, in the Page Header or Detail
section.

Problem: I've not been successful in linking Textbox2 to Textbox1. Is there
a way to do this?

I don't have any problem doing this if they are both in the Detail section.
But with Textbox1 in the Group Footer, it won't successfully link. Any idea
if this is possible? Seems like it should be very simple.

Or is there a different approach to this, to aggregate the number of entries
in a group and display it?

Thanks,

Harold
 
I discovered the problem. I can link but then I need to close the report
completely in design mode, then reopen it, then I can see the linked
textbox.

Harold
 
Harold said:
In a report, I have a Textbox1 in the Group Footer with Control source
=Count(*) and Running Sum "No".

Since this is at the bottom of the report, I would like to display the
result in Textbox2 at the top of my report, in the Page Header or Detail
section.

Problem: I've not been successful in linking Textbox2 to Textbox1. Is there
a way to do this?

I don't have any problem doing this if they are both in the Detail section.
But with Textbox1 in the Group Footer, it won't successfully link. Any idea
if this is possible? Seems like it should be very simple.

Or is there a different approach to this, to aggregate the number of entries
in a group and display it?
Click to expand...


You can't do that in a simple way in the page header, but
you can use the same aggregate expression in a text box in
the group header section.
 
Back
Top