Subform Record Count

K

Ken Kazinski

How can I get the number of records on a subform?

I do not think that dcount will work, nor can I find record count.

Thanks.
 
A

Allen Browne

Try:
=[Sub1].[Form].[RecordsetClone].[RecordCount]
replacing Sub1 with the name of your subform.

This expression should work in the ControlSource of a text box on the main
form.

(Note that RecordCount returns the number of records accessed so far, so it
may initially show 1 until it updates.)
 
Top