By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,346 Members | 2,339 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,346 IT Pros & Developers. It's quick & easy.

Subreport control won't display correctly on main report

P: n/a
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?
Dec 23 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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?

Dec 24 '06 #2

P: n/a
"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.
Dec 24 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.