Form 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?

 

[Rich@ITTC]

Hi Skelley

You can prevent your user from filtering the records on your form by going into Design view for the form, selecting the form and going to the properties. The fourth property down (on the ALL Tab) is Allow Filters - change this to No.

If you want to stop the user sorting the records according to different fields you can remove the toolbar from their view (so the sort buttons no longer appear).

I hope this helps.

[This message has been edited by Rich@ITTC (edited 07-27-2000).]