Autonumbering in Forms

[Alexis]

Here is a weird question that I hope has an easy fix. I have autonumbering
for a field in my database. I created a corresponding form with it. The
first five records in the form the autonumber matches the record number.
Now, for some reason (and this was only recently), the autonumbers are
rearranging themselves so as not to coincide with when it was entered into
the form. For instance, "ticket number #6 is shown as record 11 in the form.
When I open the table, they are all where they should be. Is there a way to
get the autonumbers to match the record number again??

 

[Jeff Boyce]

Alexis

The "record number" located in the lower left of the form is a confusing
mis-nomer. It is NOT a record number. Access' tables are "buckets o'
data", with no inherent order.

Access Autonumbers are intended to provide unique row/record identifiers,
and are NOT guaranteed to be sequential.

Your description seems to imply that you want to have a count of the records
in a table. Use a query to do this.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP