Jim
If you have a form that is opened when the file opens, you could add event
code to when it opens. If that's the "last" form that closes, you can use
that event, too.
You can create a code module to handle the writes-to-table -- you just need
events (?OnOpen, OnClose?) to trigger that code.