This property returns a Long value that indicates the current number of records in a recordset.
Syntax
var = recordset.RecordCount
Return Values
Returns a Long value.
Remarks
If ADOCE cannot determine the number of records contained in a Recordset object, the property returns -1 (adUnknown).
Reading the RecordCount property on a closed recordset causes an error.