Why are new records being moved to the front of other records?

[Modify_inc]

I'm not sure what I did, but when I enter data into a form, say it's record 10 and I click record 11 to start a new record. I can then go back to record 10, and it's still has the data I entered in the form. As you know this part is normal.

The problem is when I save and close the form and reopen it, record 10 now has the data from record 9, and the data I had entered for record 10 is moved to record 1, which is in front of my other records. It continues to do this, and I am now at record 4, which should be record 14 and I do not understand why it's doing this. At first I thought it was deleting my new records until I found them in the front of my already created records.

I could just leave it, since all my records are still there, but it's frustrating expecting your last record you enter to be at the end, instead to find it somewhere else.

I'm still learning, so I hope it is just a setting or entry I need to change.

Thanks
Mike

[John_G]

Hi -

In Access, records do not have any particular order when displayed in a form, other that the one you choose. Unless you specify otherwise, the records will be displayed in primary key (PK) order of the underlying table, if you specified one.

If you don't have a PK, and you have no ordering specified anywhere else, the order can't really be predicted.

But, you can change the display sort order any time you need to; just right-click on a form field, then select ascending or descending from the displayed popup menu.

HTH

John