Subform Record Count

[Guest]

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.

 

[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.)