If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2007 Form - Record Bar at bottom
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. -- SuzieQ |
#2
|
|||
|
|||
Access 2007 Form - Record Bar at bottom
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 "SuzieQ" wrote in message ... 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. -- SuzieQ |
Thread Tools | |
Display Modes | |
|
|