Closing Form after use of Filter/Sort Buttons

[chappie2]

I have created a "one line per record" form based on a query. The query also includes a sort order. I would like users to be able to use the buttons on the standard toolbar to either select or sort records from this form, but not have those sort/select actions saved with the form when it is closed.

Is there an action I can save in the macro to not save selection/sort changes when the form is closed?

Thanks.

Chappie

 

[SiJP]

Undo method to reset all changes to a form before the form is updated.

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.Undo
End Sub

------------------------
Hit any User to continue