Returning Record Numbers

message from JoeGriffin on 6 May 2004
I have a table of records with client details. I am browsing this data
through a form I created. I would also like to be able to include the
record number of the record I am currently viewing in my form. Does
anyone have any idead how this can be done.
Thanx
 
Larry Daugherty replied to JoeGriffin on 7 May 2004
Hi Joe,

There are lots of ways that something like that COULD BE done but you'd have
to specify what use you intend to make of such a record number before
knowledgeable Access developers are likely to respond.

Access records are stored UNORDERED in a table. Therefore they have no
natural record number. You can view them in some order by using a query but
the order can change on subsequent views due to additions and deletions.

Please post back specifying what higher purpose that record number was
intended to serve.

HTH
 

Archived message: Returning Record Numbers (Microsoft Access Error Message)