Auto number

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

Guest

I have an AutoNumber field assigned to my form. For some reason, it isn't
set to it's original default state anymore.
When I hit the "next" button, it doesn't go in order.

it jumps to random records --out of number order.

How can I fix this???
 
Check the underlying table where the Autonumber field actually lives. Check
the properties of that Autonumber field. It sounds like it's been switched
from sequential to random.

By the way, Autonumbers are intended to serve as unique row identifiers. As
such, it really shouldn't matter whether they are quasi-sequential (they
really are not, you know!), or quasi-random ... either way, they really are
not suitable for human consumption.

If you need a truly sequential numbering system for your records, and one
that is suitable for human consumption, you'll need to create your own.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Hi Jeff,

I checked the underlying table. There are only two choices --"Random" and
"Increment", which the table is set to already.

Any other ideas????
 
I'd next check on-line, using MS Access, Autonumber, random as key search
terms...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Will do...

thanks for your help!!

Bam

Jeff Boyce said:
I'd next check on-line, using MS Access, Autonumber, random as key search
terms...

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
 
Back
Top