Sorting asending/descending in forms

[Guest]

I have a form that I need to block any sorting, except for my ID field. What
is happening is they go into form view, hit sort desending in the address
field and change all my records. Then when they get out of form view it
saves and just changed all my documents (in word) that are link for address
and names. How can I stop this??

 

[Jeff L]

In the On Unload event of your form, put Me.Orderby = "". That way
they can sort it however they want, but when they exit the sorting
criteria is eliminated.