reference to subreport

[Guest]

hi,
i've made a report in Access2000 using a report with three subreports. The amounts in the subreports are summed in a field in the footer of the subreport.
I have then made a field in the main report which sums the totals from the three subreports. This worked fine in 2000 but now I have upgraded to 2003 and it doesn't work anymore.
I've made some tests, and it looks like it is no longer possible to make a reference from the main report to a field in a subreport. Is that true? As reference to the field in subreport I use the following in a textbox in mainreport: =SubReport!FieldInSubreport

 

[Allen Browne]

Try adding the ".Report" bit:
=[SubReport].[Report]![FieldInSubreport]

If "SubReport" is the name of your subreport control, then you refer to the
report *in* that subreport control as:
[SubReport].[Report]
and then the text box on the report in the subreport control as:
[SubReport].[Report]![FieldInSubreport]

If that still fails, open the main report in design view, right-click the
edge of the subreport control and choose Properties, and check the Name of
the subreport control. It can have a name different from the form that gets
loaded into it (its SourceObject).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

i've made a report in Access2000 using a report with three subreports. The

amounts in the subreports are summed in a field in the footer of the
subreport.

I have then made a field in the main report which sums the totals from the

three subreports. This worked fine in 2000 but now I have upgraded to 2003
and it doesn't work anymore.

I've made some tests, and it looks like it is no longer possible to make a

reference from the main report to a field in a subreport. Is that true? As
reference to the field in subreport I use the following in a textbox in
mainreport: =SubReport!FieldInSubreport