hi Tes,

On 11.02.2010 21:33, TES wrote:
My first column is the key and ID number for each record. One of my users
(before I locked the table) voided several of the records, and now the record
number and Id number no longer match. Is there a way to back fill the key-id
number with dummy records so the rows line up.
If you need a continuous number without gaps, then you must calculated
it before storing the records. You cannot use an auto number for that
purpose.

Use

Nz(DMax("number", "tableName"), 0) + 1

to calculate it. E.g. in the before insert event of a form:

Private Sub Form_BeforeInsert(Cancel As Integer)

Me![number] = Nz(DMax("number", "tableName"), 0) + 1

End Sub



mfG
-- stefan --