Need Subform Record Count in Report

[Guest]

I have a form and figured out how to determine the number of associated
records that appear in a subform for each ID using the RecordCount object
property and display that number on the main form. I'm now trying to create
a report that shows that number as well. I tried to just copy and paste this
field from the main form into the report (like I can do with other fields
from the form), but it fails to execute, I think, the underlying query to the
subform. (I was afraid that would happen.) However, I don't know how to
resolve this problem. Any suggestions would be greatly appreciated. And,
thanks in advance.

 

[Guest]

What are you attempting to do? Do you have a main report and subreport? Are
you simply attempting to display a count of subreport records on a main
report?

 

[Guest]

I want to display the record count, the same number that is displayed in my
form based on a query associated with a subform, on the report as well.

 

[Guest]

I would not tie a report to a form in this manner. I expect the subform or
whatever has a recordsource that can be queried/counted in your report. I
would attempt to get the count to appear in the report's record source or in
a subreport.

 

[Guest]

I resolved my problem, which was tied to figuring out the correct format of
the Control Source. Lots of trial and error before I got it resolved.
Thanks.