Ah Beng - read this

Hi,

The RecordCount will be always -1.
So, how can I get the number of records in a forward-only recordset?

Thanks,

Michel Jr.

(?)

I am not sure of the question, however...
Have you used recordset.movefirst...recordset.movenext


Lee

Hmm...
You could loop thru the recordset and add the counter.

eg:

Code:

---

Dim i as Long

Do While Not rs.EOF
    i = i + 1
    rs.MoveNext
Loop

---

The only problem is you'll have no way to move back as it's forward only.