When opening a form, I would like it to sort like the query that drives it. (Ascending on 2 fields)
But it captures the last sort order used when the user closes it and defaults to that sort order the next time the form is opened.
I see that in Access 2007 there is a form property called "Order By On Last" but it does not exist in Access 2003.
Thanks for your help.