Is the database hosted over a network or local to your computer? If it is local to your computer, you might use File Options, OnLastWindowClose to switch to your opening layout when the file is closed. If it is hosted from another computer, take the file down off the server, open the file, navigate to the opening layout and then close the file and put it back up on the server.
Thanks for the tip. I'm using a local computer. Using OnLastWinndowClose works great.