Autonumber tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My autonumber in my table database skipped from 1017 to 1019 but not in my
form. What would cause this to skip a number in my table
 
Hi Cindy

Your table does not always sort on the autonumber (or record 1018 was
deleted). The make the form sort in a specific way create a query based on
your table then sort this query how you want. Open the form in design view
and use the new query as the record source.

This will ensure the order of records is shown in a way that you decide (in
the query sorting)
 
AutoNumber will develop gaps!

Form example, when you start adding a new Record, JET will allocate a value
to the AutoNumber Field for this new Record. If, for some reason, you
cancel the addition, the allocated value will NOT be recovered and the next
new Record will (usually) be allocated the next value.

If you referred to the number in the Navigation Bar of your Form, that is
NOT the value number of your Record. It is actually the RecordNumber of the
Record in the Form's Recordset. Note that the AutoNumber value of a Record
is fixed but the RecordNumber depends on your selection criteria and the
sorting on your Form. Try sorting your Form Descending and it is likely
that the RecordNumber of each Record will be different from the AutoNumber
value.
 
Back
Top