Get information from one subform to another 1

[MMSMSD]

I have a report with two subreports (SUB1 and SUB2). Each subreport has it's own query to grab specific data from separate tables. SUB1 displays a listing of fields, based on a specific date. The last field in each record (TVMIL) is a number. The second subreport is supposed to take the SUM of TVMIL and add additional items later on. The problem I'm having is that SUB2 doesn't want to see the TVMIL field in SUB1 to do a SUM and continue from there. In all other respects, the report works fine.

I previously had all the information from both subreports into one query (and one subreport) but, since each subreport could have a different number of entries, I would wind up with duplicate entries the moment both sections had more than one entry. That's what made me try to break it up into two separate subreports. I hope this is enough information to go on. Thanks.

 

[Remou]

You could try:
1. Add a textbox to SUB1 that sums TVMIL, let us call this textbox SumOfTVMIL.
2. Add a textbox to SUB2 and set the Control Source to:
=[Reports]!Report1![SUB1].Report!SumOfTVMIL

Where Report1 is the name of the main report and SUB1 is the name of the subreport control, not the name of the report contained by the control.

 

[MMSMSD]

That did the trick. Thanks!