title: Sorting records on a form in MS Access 2010
body: <p>I had a question last week about how to do a sort of ascending ID numbers by year for a SQL query.</p>
  
  <p><a href="https://stackoverflow.com/questions/25529773/doing-a-secondary-sort-by-year-in-a-sql-query/">Doing a secondary sort by year in a SQL query</a></p>
  
  <p>I followed those instructions and the result was great for my table. The data in the resultant query was used to create a table that was then linked to a form. Unfortunately, as I add new records to the table, am I seeing that the sort is not respected after data entry (that is, new records are automatically displayed first when browsing records with the form instead of last). Is there a way to do a sort with ascending ID numbers and year within the form itself? When I try to use the ORDER BY year (date) expression in the form properties I'm getting an "undefined function in expression" error.</p>