Removing OrderBy

[Brad]

I want to open a form and remove the OrderBy property. Right now it prompts
me for the field to order by, but depending on the query, it might not
exist.

I tried Me.OrderBy = "" on OpenForm and Load. I can't remove this. Any
suggestions?

Thanks

 

[Fredg]

You need a bit of VBA.
In the Form's Load event:

Me.OrderByOn = False

 

[Brad P]

Thanks for your replies.

I ended up using this command in the form
RunCommand acCmdRemoveFilterSort