How to hardcode order by

[ddtpmyra]

Inside the form properties under data I type 'ORDER BY' date. But everytime the user re-ordering the columns it didn't go back to where it should be organize, which is the date.

Is there a way to hard code this during the form event 'on load' or 'on open'?

Your help is much appreciated!

[Seth Schrock]

I'm not sure I understand the question fully, but could you base the form off of a query that sorts by the date? I believe that this would still allow users to change the sort to the way that they need it at the time, but every time the form is opened it would be sorted by the date.

[ddtpmyra]

Hi Seth Schrock

That's exactly what I'm doing right now. I even put the Order by properties set by date. But every time I do my test and order it by firstname, lastname and when I close and open it, the form inherit the last order by. By the way, I'm using access 2003... and this is the reason why im looking a ways how to hard coded it during an event form.

[Seth Schrock]

I did some testing and what I found was that if I sent the form property Order By On Load (under the Data tab) to no, then it didn't remember the previous order settings that I would change. If it was set to yes, then it did remember how I had left the order. Also, I found an article that said that this property had some bugs prior to Access 2007. Some code you could try if the property setting doesn't work is in the Form's on load event. Just put in

OrderByOnLoad = False

Let me know if that works.

[ddtpmyra]

Thanks Seth! It works... I just have to turn it off so i wont capture the last sort in the memory.