Autonumbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Asif - 24 May 2007 11:20 GMT

I have a form with some data being displayed when I go to update the
form an update query runs asking I'm about to update 1 row and I click
yes. The Autonumber (ID field) displayed in this form changes but not
from say 1 to 2 but rather it jumps from 1 to 3. Any ideas why this is
happening?

Thanks

Reply to this Message

Joseph Meehan - 24 May 2007 12:27 GMT

> I have a form with some data being displayed when I go to update the
> form an update query runs asking I'm about to update 1 row and I click
[quoted text clipped - 3 lines]
>
> Thanks

I suggest you may not want to use Autonumber for that use. Autonumbers are
designed to provide unique numbers. It in not designed to provide numbers
in order and for a number of reasons may not do so. As a result using them
in any application where the user sees the numbers is likely to end up with
confusion.

There are other ways of providing the numbers you want depending on the
particual application.

Signature

Joseph Meehan

Dia 's Muire duit

Reply to this Message

Jason Lepack - 24 May 2007 13:16 GMT

The reason for the jumps is as follows. Create a new record
(Autonumber = 1) If you "dirty" (write something into a field) a form
Access assigns the next Autonumber to that record (Autonumber = 2) and
it's gone. If you cancel that new record and then dirty it you get a
new autonumber (Autonumber = 3).

Cheers,
Jason Lepack

> I have a form with some data being displayed when I go to update the
> form an update query runs asking I'm about to update 1 row and I click
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message