Access 2007 Form - Record Bar at bottom

[SuzieQ]

I've created a form. There are over 290 forms displayed in the record bar
below the form. Recently if I scroll through the created forms with the
record bar one form at a time, the form numbers which were created using
autonumber, no longer scroll through consecutively and tend to jump around.
Any ideas why? How can this be corrected to allow scrolling through the
forms consecutively.

 

[Jeff Boyce]

Those "numbers" at the bottom ... they're meaningless! OK, they are NEARLY
meaningless. They are only there to keep track of how many, not which ones.
Each time you filter or re-sort or ..., the numbers stay "1, 2, 3, ..." but
the records aren't the same.

Those numbers are NOT the Autonumbers.

Now, don't count on the autonumbers, either! While they are intended to
serve as unique record identifiers, they are generally unfit for human
consumption and are not guaranteed to be sequential (i.e., they are no good
for 'counting' records).

If you need to know how many records, use a totals query.

Regards

Jeff Boyce
Microsoft Office/Access MVP