forms sort restore

[skelley]

Have a form based on a query that sorts my form based on 2 fields in descending order. When a user applys a filter or sorts it another way, that user gets that same sort the next time he opens it and I can't restore the original 2-field descending sort that the query originally had it in.

Can someone help me?

 

[tbprog]

Hi is the sort order defined in the query or on the form.
If in the query ensure that the forms ordeby is blank on opening the form