Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Aug 2001
    Location
    Maine, USA
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sort a form by multiple fields (2000 SR1)

    There's probably a very simple answer to this, but my poor brain seems frozen today.

    I've got my to-do list set up as a simple table. I created a query to select only open items, then made a form based on that query. (So far, so good.) The query sorts the items by priority, then by date added, then by category.

    My form used to follow this sorting system, but today I used the A-Z sorting icon, and now I can't seem to get the form back to following that three-level sorting system. I've tried making filters, but that didn't work.

    Is there a way I can force the form to sort on multiple fields? Thanks!

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

    Re: Sort a form by multiple fields (2000 SR1)

    Try Records | Remove Filter/Sort.

    If that doesn't help, open the form in design view and clear the Order By property of the form.

  3. #3
    Star Lounger
    Join Date
    Aug 2001
    Location
    Maine, USA
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sort a form by multiple fields (2000 SR1)

    You are my hero! <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

    Records | Remove Filter/Sort was just the ticket. I hoped it would be something as simple as that! Thank you so much for your quick answer.

Posting Permissions

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