Form recordcount

[Guest]

How can I count the number of records displayed in a subform (datasheet view).

Thanks.

 

[Allen Browne]

Examine the RecordCount of the RecordsetClone of the form.

For example:
=[Form].[RecordsetClone].[RecordCount]

If the form is based on a query or linked table, that might show 1 when the
form is first opened, and then update later once the records have been
loaded.

The count in the Nav Buttons increments when you move to the new record. If
you want to simulate that, use:
=[Form].[RecordsetClone].[RecordCount] - [Form]-[NewRecord]