If that field is an autonumber you can Compact & Repair, close Access, open
Access, and append missing records.
--
Build a little, test a little.


"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.

Thanks……