Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Apr 2003
    Jacksonville, North Carolina, USA
    Thanked 0 Times in 0 Posts

    Columns' Sort Order on a Form (11.8166.8172 (2003)

    Attached is a snapshot of a database form that employees are entering their visit info into. Sometimes the dates are not enterred in sequence. I just had an employee exit the database and when she went back in thought the prior entries were not saved because she "couldn't find" the prior entries so she enterred the info again. Is there a way to have the visit column auto sort A-Z upon exit?
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Columns' Sort Order on a Form (11.8166.8172 (2003)

    Create a query based on the visits table.
    Add the fields that you need to the query grid.
    Sort the query on the Visit Date field.
    Save the query.
    Set the Record Source property of the form to the name of the query.
    The records in the form will be sorted by Visit Date when the form is opened.

Posting Permissions

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