Clear All Sorts

[michaeljryan78]

I have a Query Form that I want to have the user sort by clicking on the sort button in the access ribbon. Then, I want to programically remove the sort on the OnClose event of the form.

I have tried

Me.frmtester.Form.OrderBy = ""
Me.frmtester.Form.OrderByOn = False

But that didn't work, when I reload the form the filter is still in place. Any Ideas??

 

[michaeljryan78]

Figured it out. I set the Order By On Load to "No" and that did the trick.