Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2003
    Posts
    13

    Unanswered: Sorting Dates in a SubForm

    Any tips on how to do this? If a date-specific record is added after the data was first entered into the subform, the information will not sort.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    It will sort of you force a re-retrieve of the sub-form. Otherwise it just kind of hangs out at the bottom!

    -PatP

  3. #3
    Join Date
    Jul 2003
    Posts
    13
    How do you go about forcing a re-retrieve?

    Thanks...

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    If you are using Access-2000 or later, you can simply set a sort on the sub-form. If you want to force the sub-form to requery, it will get any new data from the disk and apply the specified sort from the query.

    -PatP

Posting Permissions

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