Order By option on a form

[anns]

I have had the following problem happen a number of times. In a form's
properties I will enter a field name in the Order By option. The data will
show in ascending order in the field for a period of time and then the order
disappears. When I check the form, the field name is now missing from the
Order By option. I know no one has deleted it from the form so why does it
disappear? Thanks.

 

[Beetle]

If you want something permanent, the form is not the place to do it as
the form will not retain it. You're better off using a query as the record
source for your form and setting the order by in the query.