You can't insert a record between two records, you can only add to the end. But as Speakers_86 notes, you should have a field that sorts the records the way you want so that whatever record you add to the end immediately appears wherever you want it to. For example, in my table I have a field called SortOrder where I put the Lastname, Firstname (as in Doe, John) so that when I add Amy Aaron to the database, she appears before Amy Abelia after I save the record. I also create a Rownum field (which Access doesn't automatically have) and make it an autonumber so that I can always go back to the original order the records were entered should I so choose (though I rarely do so).