Function to run upon MS Access quitting

[Guest]

Am stumped and a troll through the usual sources did not turn up anything

How do I get a function to fire when a user either clicks the close window
button on the Access application window or chooses File/Quit? (the database
window itself is hidden in my db)

Thanks for any thoughts
James

 

[Granny Spitz via AccessMonster.com]

How do I get a function to fire when a user either clicks the close window
button on the Access application window or chooses File/Quit?

Create a hidden form that opens when the app starts. Put your closing
function in this form's Close event. When the app quits it will close this
form, executing the code you put in this form's Close event.