First, the AutoNumber field is for autonumber in sequence. Is
this Invoice table link to another autoNumber field in another
table?
Assume you use ony Invoice table:
To change the Id field of the table, you can use DAO or ADO. Do you
know this?
Let say you have Id = 10007, but want to change it to say 10000,
you need to use DAo or ADO to change it. Capture 10000 first, use
recordset object to change the old id=10007.
If you want the NEW ID say 10000, copy this table, delete the old
table, change this copy table with the old table name. everything
will begin with 10000.
