tags:

views:

126

answers:

1

If I am looping through an ADO.Recordset (with while not recordSet.EOF), is there a way to detect that I'm on the last record?

+1  A: 
rs.Index == (rs.RecordCount - 1)

Or you could just call MoveLast.

Austin Salonen
MoveLast is not what I want... I want to *detect* the last, not *make* it the last
JoelFan