Is there a way we can create a consistent pre sorted environment in Microsoft Access 2007. We have a Windows 2008 Server with an ACCDE and ACCDB file stored there. Users from 5 different clients connect. It seems that several different areas in the forms we have seem to get changed either by the last user that touched the form or by the application (Microsoft Access 2007) itself. We need the data to always start with newest to oldest instead of oldest to newest.
Users launch the application and are used to clicking the Go To Last Record button at the bottom. There they can Go Back One record at a time and see the nights records from the earlier shift. What happens is they cannot find the records consistently. What happens is the current sort makes users think they have lost the records and they are confused as to how to retrieve them. Is there any way to make this consistent.
So users start with the last (or most recent records) and can then simply go back one record at a time. ( Also if there are subforms involved here can you set that for individual forms or can it be set for all forms globally.) Thank you.