Tapping a subreport info to the footer 1

[perrymans]

I have a report that has a subreport in the detail section. Within this subreport are two fields, Subsystem and Revision, that I would like to have display on the Page footer of the main report, not the footer of the subreport.

Currently, the footer of the subreport is hugging the expanding continuous detail of the subreport, rather than moving to the bottom of the page. So I added a Page footer to the master report to get the info to the bottom of the paper.

So now I want to extract a couple of fields out of the subreport and into that page footer.

Thanks. Sean.

 

[dhookom]

I would try place a invisible text boxes in the detail section like:
Name: txtFromSubA
Control Source: =subrpt.Report!txtFromSubA
Name: txtFromSubB
Control Source: =subrpt.Report!txtFromSubB
Then in the Page Footer add text boxes:
=txtFromSubA
and
=txtFromSubB

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[perrymans]

Damn that's hot!!!

I can't believe it was that easy. I had been trying the same thing, except without the textbox in the Detail section.

Why does this make a difference?

Thanks again. Sean.

 

[dhookom]

I don't know. There are generally issues with attempting to pull values from controls across section boundaries.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[perrymans]

I take it back, it isn't working, quite right.

The subReport is a continuous form, which seems to be causing the problem. The value on the main form (in the footer) lags the value of the subform txtbox by one record.

So the subReport value says P2, the report footer says P3, and the report footer goes to P2 on the next page.

Any ideas? Thanks. Sean.

 

[dhookom]

Have you considered creating a totals query that calculates your values by your main report grouping? You can then include the totals query in your main report's recordsource and don't have to worry about grabbing values from the subreport.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[perrymans]

I don't quite understand what you are getting at, but I do know that I am not totaling anything. The numbers are Revision numbers, which differ from cable to cable (like Rev. A, B, or P1 etc.).

Sean.