The Reason the auto number goes all over the place is because if you delete a record, it ignores any deleted records. To get round this, every time you want to add a new record, use a recorset to grab the last id number, (SELECT idnum FROM tbltest ORDERBY idnum) then move to the last record, add one to it and you have your new record.

As long as the numbers arec already sequential this will work

Hope this helps

Ian