I have an MS Access 2010 database which when opened, displays one of three Care Home Duty Rosters as part of its top menu. It can be an Early, Late or Night Roster depending on which 8-hour segment of the day and the date on which the database was opened. This arrangement works fine for the instant that the database is opened. We alight on the required dated record in the required Roster file. All well and good so far, but if whilst the database...