Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    7

    Unanswered: Order of Record in Form Changes/Why?

    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.

  2. #2
    Join Date
    Nov 2003
    Posts
    6

    Re: Order of Record in Form Changes/Why?

    I ran into a similar problem. I just put the "ID" on the bottom of every page.

  3. #3
    Join Date
    Oct 2003
    Posts
    7

    Re: Order of Record in Form Changes/Why?

    Originally posted by bennettR
    I ran into a similar problem. I just put the "ID" on the bottom of every page.

    That's the only quick fix that I can see also. Thanks for the response.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •