thats not the way autonumber works
if you must have a sequential series then you need to implement your own mechanism to get the number, rather than rely on the db to do it for you. The whole purpose of a system generated number is that it has no meqaning outside the system.
consider using the max() clause in a select statement to find the current highest number.
if you want to find missing numbers then you need to do some more work
you need to open a recordset, iterate through each row to find a gap, and return that number.
If the app is to be used in a multi user environment then you need to do a lot more, to ensure that you dont get more than one user trying to use the same number, by using table locks.
I'd rather be riding on the Tiger 800 or the Norton