Autonumbers seem to be a daily topic lately.
If the linear sequence of the field is important to you, don't use
Autonumbers. It is intended to be a simple method of assigning a
unique index to a record. If that index needs to mean something to you
or your users, you should employ a different method. The help file
contains examples of how to re-order the field, but you will come into
this situation again. Either don't worry about the number, or use a
different indexing method.

There is nothing to fix.  An autonumber is simply a unique number that can
be used as a key.  Your users should rarely (if ever) see the autonumber
field.  It is an internal item, not something for the end user.

If you care about the number, you need to create your own numerical field
and create code that will find the highest entry and add one to it when
creating a new record.

For exact information on how to do this, look at previous posts on the
topic.  Search for "incrementing field" or "increment value".

There are several here...
http://groups.google.com/groups/search?hl=en&ie=UTF-8&oe=UTF-8&q=microsoft.publi
c.access+increment+field+form

Good luck!