Subreport control won't display correctly on main report

[Jimmy]

On the subreport, records are grouped by WorkDate. In the WorkDate header
there is a textbox named DateCounter with the control source =1 and running
sum set to yes. In either the report footer or the WorkDate footer (I tried
both with no difference) is a textbox called DateCount, the control source
of which is =DateCounter. If this subreport is run as a seperate report,
DateCounter shows 1...2...3...etc for each seperate WorkDate and DateCount
in the footer will show the same number as the last WorkDate grouping. On my
main form I have a textbox, Days, with a control source of
=[rptSummaryLaborSubreport]![DateCount]. In theory, this should display a
number that corresponds to the number of WorkDate groups in the data subset.
Also the same as the field DateCount on the subreport. It does not, however,
but rather displays 1 everytime. What am I missing?

[Larry Linson]

Possibly, you are referencing the Control improperly.

From the main Report, where sbrSubRep is the name of the Subreport Control,
try

sbrSubRep.Report!DateCount

Larry Linson
Microsoft Access MVP

"Jimmy" <no**@none.comwrote in message
news:fI*******************@fe08.news.easynews.com. ..

On the subreport, records are grouped by WorkDate. In the WorkDate header
there is a textbox named DateCounter with the control source =1 and
running sum set to yes. In either the report footer or the WorkDate footer
(I tried both with no difference) is a textbox called DateCount, the
control source of which is =DateCounter. If this subreport is run as a
seperate report, DateCounter shows 1...2...3...etc for each seperate
WorkDate and DateCount in the footer will show the same number as the last
WorkDate grouping. On my main form I have a textbox, Days, with a control
source of
=[rptSummaryLaborSubreport]![DateCount]. In theory, this should display a
number that corresponds to the number of WorkDate groups in the data
subset. Also the same as the field DateCount on the subreport. It does
not, however, but rather displays 1 everytime. What am I missing?

[Jimmy]

"Larry Linson" <bo*****@localhost.notwrote in message
news:gcojh.1153$4e.11@trnddc04...

Possibly, you are referencing the Control improperly.

From the main Report, where sbrSubRep is the name of the Subreport
Control, try

sbrSubRep.Report!DateCount

No, the reference is correct, as above, and I do not get an error (#Error or
#Name) it simply displays 1 on every record.