Current Record Number

[Luis]

Hello
Is it possible to get the current record number while looping through a
record set?

Something like this:

Do

---> The current record number is rs.???
rs.Movenext
Loop While Not rs.EOF

Thanks.

Luis

 

[John Spencer]

Not sure what you want. You could mean you want the position of the current
record in the recordset. If so,
rs.AbsolutePosition
returns the Position of the record in the recordset.


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County