What governs how records in an Access 2007 "continuous" Form are ordered?
Posted on 2009-04-02
I am developing an Access 2007 "project" (.adp) as a front-end to a SQL Server 2005 Express database.
I have an Access Form that I am displaying in "Continuous Form" mode, in which I would like the records to be listed in a particular order.
I have tried two approaches :
When I specify my ordering preferences in the Form's "Order By" property, with its "Order By On Load" property set to "Yes", it does not do it.
If instead, I declare "Me.OrderBy = xxxxxxxx" in the Form's "Form_Load" procedure in the VBA behind the Form, it does not work.
These do not work when they are done on their own, but when I have both in place the records are listed in the Form in the sequence I want.
Can anyone tell me why I am having to do both; ie fill out the Form's properties AND a bit of VBA coding?
I would have thought that one or other of these would have been sufficient on their own.
Any advice gratefully appreciated.