I can't get the record number in ADO recordset [RESOLVED]

I've tried with .AbsolutePosition but it gets -2 or something like this :confused:

Can somebody help me, please?

Thanks in advance.

My mistake, the value was -3 (what means EOF), I believe I was in the first record.... :blush:

Quote:

---

Originally Posted by Jethro Tull

I've tried with .AbsolutePosition but it gets -2 or something like this :confused:

Can somebody help me, please?

Thanks in advance.

---

The AbsolutePosition is not correct if u are using a Server Side cursor.
Before opening the recordset, make it a Client side cursor

VB Code:

rs.CursorLocation = adUseClient

Then the absolute position should return correct value