I have a form in which a user enters records. When needed the user can click on a hyperlink (on the same form) that leads them to a Word document to do a mail merge using the info from the Access DB. When I do a mail merge, I want to do a specific record and not all the records in the DB. So I type in the number of the record I would like to mail merge (based upon the number at the bottom of the screen in Access). What should happen is that person's record should be the info that pulls up on the mail merge letter, but instead it's another record. When I go back into the Access form, the order of the record has changed. Why does this happen? This only happens when I am adding a new record. So instead of the last record entered is the last record in the entire form, it can change and another record that was entered previously is now the last record. I thought unless you specified a sort of some kind, that records would go in the order they were entered.