Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    order in ascending order (Access 2000)

    After filtering the form i would like to order the products names, with the field ProductName in an ascending order.How could i do that ?
    Me.FilterOn = False
    Me.Filter = "CustomerID = 1902"
    Me.FilterOn = True

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: order in ascending order (Access 2000)

    You don't have to use

    Me.FilterOn = False

    To sort, use the OrderBy and OrderByOn properties; they are similar to Filter and FilterOn:

    Me.OrderBy = "ProductName"
    Me.OrderByOn = True

Posting Permissions

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