Record Count

[David W]

Is there a simple way to count the number of records loaded into a subform?

 

[Sandra Daigle]

From the main form? Here's how I would do it - where 'sfrmTest' is the name
of the subform control on the mainform:

With Me.sfrmTest.Form.RecordsetClone
If Not (.BOF And .EOF) Then
.MoveLast
End If
Me.txtRecordCount = .RecordCount
End With