OrderBy Property

[isandell]

I am struggling with OrderBy and OrderByOnLoad and would appreciate some help.

It seems that everytime the user sorts on a column of a query, the sort order is added to OrderBy field property and is saved if the user "Saves Changes" on exiting the query. Next time, the sort order is added to what is already in OrderBy, producing a longer and longer list.

Some queries run extremely slowly with multiple fields in Oderby.

How can I prevent this happening? I have tried setting OrderByOnLoad to Off, but this seems to make no difference to either the addtion to orderby or the sorting when the query is oponed.

Thanks

 

[boblarson]

1. Don't let them open queries directly.

2. Use a FORM to display the queries and it can be set as a DATASHEET VIEW so it LOOKS like a query but they won't know the difference. Then you can use the OrderBy and it should not save.