I have a form based on a query that sorts by 2 fields (year and project#). When I open the form for the first time it sorts correctly. After I change the sort criteria while using the form and save and reopen it, the form is sorted by the changed criteria even though the query hasn't been changed. How can I make sure that the form is sorted the same way everytime it opens?

You can set the form's Order By property to the field you want by using the On Open event. That way even if someone decides to sort by another field when they are using, when the form is opened again, it sorts using the original field.

You can set the form's Order By property to the field you want by using the On Open event. That way even if someone decides to sort by another field when they are using the form, when the form is opened again, it sorts using the original field.