Changing Date Sort in Forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Our DB consists of a main switchboard where there is a drop down box of
patient names. One you choose the patient you are looking for you can then
choose other command buttons which lead you to the patient's visits, etc.
Some of forms are not sorted right by date. For example, if I enter a visit
say from 2002 today it will stay as the last record and not sort
chronologically when I close the form. How did I correct this?
 
Our DB consists of a main switchboard where there is a drop down box of
patient names. One you choose the patient you are looking for you can then
choose other command buttons which lead you to the patient's visits, etc.
Some of forms are not sorted right by date. For example, if I enter a visit
say from 2002 today it will stay as the last record and not sort
chronologically when I close the form. How did I correct this?
Click to expand...

Check the Form's Recordsource. I'm guessing it's just the name of the
visit table. If so, click the ... icon by the Recordsource property in
the form's Properties; accept Access' offer to open a Query based on
the table; sort by the date field (or any set of fields you want); and
close the query accepting Access' offer to save the SQL.

John W. Vinson[MVP]
 
Back
Top