This property indicates the current number of records in a Recordset object.
var = object.RecordCount
Returns a Long value.
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.