Subform sort

[IanT]

How can I sort information held in a subform by date. My date format is 07-Nov-02.

 

[dan-cat]

Go to design view of your sub-form - go to edit - select form - go view - select properties - click the ellipsis next to the properties field - this will open your query builder for the form - make sure all the fields that are contained within the form are contained within the lower half of the page. Then select your date field and change the sort property to "ascending" or "descending" depending on preference.