Auto number

[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???

 

[Jeff Boyce]

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

 

[Guest]

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????

 

[Jeff Boyce]

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

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Will do...

thanks for your help!!

Bam

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

Regards

Jeff Boyce
Microsoft Office/Access MVP