I have a form that shows one record at a time and there are over 900 records.
Each record shows a project and one of the fileds is 'Status'.
I have a few maros that can be selected on the form via a button and the macros filter by Status type, for example, if you select the In Progress button, the form now only shows the first record that is 'In progress' and selecting the next record takes you to the next In Progress record.
Macro In Progress:
InProgress - Applyfilter - [Status] = "In Progress"
Show InProgress - ShowAllRecords
Each Record has a "Last Updated Field". How can I get the filtered records to order by this field?