Turn Off/Prevent OrderBy - How?

[rsACC99]

Access 2007. Usually my form is sorted by the Record Source query its based on. Form Properties: Filter - nothing, Order By - nothing. When I Filter-By-Selection an unwanted, previously used sort order is (sometimes?) applied. The property sheet Order By remains blank. I've tried programming the Unload Event:

Me.Filter = ""
Me.OrderBy = ""
DoCmd.Save acForm, "FormName"

How do i stop the form from applying a sort it is somehow saving -OR- how do i automate the deletion of a saved sort -OR- prevent the save in the first place?



thanks!

[orange]

You could try

Debug.print me.Recordsource in the Open event for the Form
This should show you what Access is using.