First, you'll need a Timestamp field which is set to auto-enter a timestamp when the record is modified.
Then create a script that basically does the following:
Show all records
Sort records (based on the Modified field, in ascending order)
Go to the last record (which will be the most recently modified record).
Then go to File menu > File Options and specify the script to run whenever the file is opened.