Form Sort issue

[nschroeder]

I have a couple of forms with queries as the data source that sort the data several levels deep. If I sort the data on the forms, they retain the new sort sequences, even if I close and reopen the forms, or completely close the database. In the past, I thought Access would ask if I wanted to save the changes when I closed a form after sorting, but now it seems to do it automatically. The only way to retrieve the original query sequence is to go into Design mode and delete the Order By property that it has put there. Obviously I don't want the users to have to do this every time. This seems like a bonehead issue. Am I missing something obvious?