A better way to determine the number of records in a continuous form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rob - 04 Nov 2004 16:31 GMT

Is there a faster/cheaper way to determine the number of records being
displayed in a continuous form?
I always did:

dim rs as dao.recordset
set rs = me.recordsetclone

if rs.recordcount = 0 then
msgbox "no records"
else
rs.movelast
msgbox "you have " & rs.recordcount & " records"
endif

Thanks
Rob

Reply to this Message

Bruno Campanini - 04 Nov 2004 17:02 GMT

> Is there a faster/cheaper way to determine the number of records being
> displayed in a continuous form?
[quoted text clipped - 12 lines]
> Thanks
> Rob

Put:
=[Recordset].[RecordCount]
in a Control Source of a Text Box in your Form.

With me it doesn't work correctly on first
15-20 records.

Ciao
Bruno

Reply to this Message

Ron Devonish - 04 Nov 2004 19:26 GMT

In the Control Source of a Text Box control simply write:

=Count(*)

Ron

Reply to this Message