Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2011
    Posts
    26

    Unanswered: Quick table/query question

    I have a "visits" form in which data was inputted according to date. Currently, when I want to go back and view this information in form view and scroll though the various visits, I can only see the information ordered by when it was entered and not chronologically by the visit date. Is there any way for this information to be sorted by date automatically upon the closing of a form using vba or would I have to use a query? Thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    if you store the date and time of each visit then you can sort. you can change the sort order of rows displayed in forms (or reports) as required
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jun 2011
    Posts
    26
    Thanks for the reply healdem. That's exactly what I would like to do, just change the order of how they are displayed in the forms, a change within the table isn't necessary. How would I go about doing this? Thanks again.

Posting Permissions

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