Current Record Number

  • Thread starter Thread starter Luis
  • Start date Start date
L

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
 
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
 
Back
Top