Order of records on form

[Haynesey]

This may be really simple but is their a simple way to sort the order of records on a form, with the most recent records in terms of date being shown first?

Thanks
Lee

 

[Rich_Lovina]

There's a wee arrow in the bottom left corner, click the < and your first record appears, and records are then in that order! Of course, click on your date field 1st.

 

[Dave Eyley]

If the form is based on a query or recordset it's easy. If not, it may be worth making the table a query by going to the 'RecordSource' property and clicking on the ... beside the name of the table. This will ask if you want to base the form on a query. Say YES and in the query builder pull all the relevant fields to the grid.

In the grid column you want sorted click in the 'Sort' row and set the option to either Ascending or descending as required. Usually I set this one, for dates, on descending as I would want the records to list from the most recent date backwards.

This method does not require any further action by the user and will always show the records sorted when the form is opened.

Dave E