Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004

    Unanswered: Access Form Sorting Changing

    I have a Form based on a query that Sorts Last Names, Ascending.

    If I use the Menu Buttons to Sort the Form Descinding by Last Name and close the form, the next time I open it, the Descending sorting is still there.

    If I open the Form in Design View, the Order by says Descending.

    Is there a fix for this?

    Thanks - AB

  2. #2
    Join Date
    Oct 2003
    Provided Answers: 1
    Try to use the ASC in your Forms's RecordSource

    In your RecordSource of the Form use "SELECT * From yourTable ORDER BY someField;"

Posting Permissions

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