How to refresh to original when form is loaded after the user right click sort?

[emtang]

How to refresh to original when form is loaded after the user right click sort

Steps:
1. Form is loaded.
2. User right click on sort A-Z in Contributor.
3. User wants to get back the original sort when the form is opened.

How?

Please help

** Edit **
[imgnothumb]http://bytes.com/attachments/attachment/4688d1296694690/form.jpg[/imgnothumb]

[orangeCat]

Is there an option to Remove Filter or Sort?
If so, click it.

[Stewart Ross]

You can place a command button on the form labelled, say, "Sort in Normal Order", and in its on-click event put the following lines:

Me.OrderBy = ""
Me.OrderByOn = False

-Stewart

[NeoPa]

In the Records Menu there is an option Remove Filter/Sort. The operator can choose this unless you have menus disabled or hidden.