Depending upon the type of  recordset, some do not fully populate until you
have moved to the last record. A Snapshot is an example of this. So in order
to get the correct record count you would have open the recordset and then:
rsData.MoveLast
rsData.MoveFirst
lRecordCount = rsData.RecordCount

----- Original Message -----
From: "Mitchell Spruill" <MSpruill@M...>
To: "professional vb" <pro_vb@p...>
Sent: Tuesday, January 16, 2001 11:39 AM
Subject: [pro_vb] Getting the record count


> I saw this earlier but lost it.
> Can someone tell me again the correct way to get the recordcount from a
> recordset.
>
> Thanks a bunch.
>
> (I'll not lose it again)
>
> Mitch Spruill
>
>
>