want to save the record number in a field

This shold be simple, but I can't find and info on it. When starting a new
record I would like to populate a field with the record number and save it in
in the table.

Record numbers you see at the bottom of the display are 'relative' only.
Access stores records like a barrel of bricks, all in a jumble. You have to
sort the records in a query, form, or report.
But you can use a field with an Autonumber to number records. The numbers
may not be continous without gaps but will be a unique value.

--
Build a little, test a little.


"fransquest" wrote:

This shold be simple, but I can't find and info on it. When starting a new
record I would like to populate a field with the record number and save it in
in the table.

On Tue, 24 Nov 2009 10:33:03 -0800, fransquest
wrote:

This shold be simple, but I can't find and info on it. When starting a new
record I would like to populate a field with the record number and save it in
in the table.

What do YOU mean by "a record number"? Access doesn't have record numbers, so
you'll need to implement it yourself. Do you want a number assigned
sequentially in order of data entry? What if a record must be deleted: should
all later records get renumbered? Immediately, or can you do it in a batch
process periodically? If you change the order of records do you want the
record numbers to resequence? What specifically do you want these record
numbers to do for you?
--

John W. Vinson [MVP]