Changing Date Sort in Forms

[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?

 

[John Vinson]

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?

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]

 

[Guest]

When you add a record, you may have to do a requery to get it to sort
correctly.