Long Winded Records Count

[Guest]

This has been bothering me since Access 95, but someone might be able to
explain to me how to get the record count without unneccessary steps.

Every form in which the "navigation buttons" property is set to yes,
displays the total number of records as well as the current record number.
Why is it that then such counts are not available with a simple
"me.recordcount" -for instance- and one has to go through the long winded
procedure of:

-creating a recordset clone,
-movefirst,
-movelast, and then finally extract the
-record count.

or, in alternative, one has to create a query just to count the number of
records which is already displayed in the actual form navigation area?

Thank you

 

[Guest]

Gino,

You should be able to use:

Me.recordsetclone.recordcount.

 

[Guest]

Thank you Dale. It works and it is simple as it should be.