Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Thanked 0 Times in 0 Posts

    sorting a datasheet form (access 2003)

    I have a form I use to show a failure rate percentage. The form is displayed in datasheet view. The problem I have is they want the form to show the failure rate in descening order. I sent up the query below the form to do this I even added the statement below to the order of the form but whenever a user sorts the column to ascending order the form stays that way. Is there a way that if someone does this when the close the form it reverts back to descending oder? Thanks...

    Field name: NSFailureRate
    Oder on form NSSearchFull_qry.NSFailureRate DESC

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Crystal Beach, FL, Florida, USA
    Thanked 41 Times in 40 Posts

    Re: sorting a datasheet form (access 2003)

    You might try setting the OrderByON property of the subform to False, and/or set the OrderBy property to a zero-length string.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: sorting a datasheet form (access 2003)

    You could create an On Load event procedure for the form:

    Private Sub Form_Load()
    Me.OrderBy = "NSFailureRate DESC"
    Me.OrderByOn = True
    End Sub

Posting Permissions

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