Returning Record Numbers

J

JoeGriffin

I have a table of records with client details. I am browsing this dat
through a form I created. I would also like to be able to include th
record number of the record I am currently viewing in my form. Doe
anyone have any idead how this can be done.
Than
 
L

Larry Daugherty

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
 
Ï

ÏãÏã

JoeGriffin said:
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
 
Top