I have an Access Application which was developed in Access 2003. Recently, we arranged for Access 2007 clients to connect to it - which works OK, except for one form. If you connect using Access 2003, you get the records displayed according to the OrderBy propery of the form (newest first). If you connect to it using Access 2007, the form displays the records in order of their primary key instead (effectively oldest first). It's as if 2007 is simply ignoring the OrderBy property. Does anyone have any ideas on this?