How do I display a msgbox when my db closes?

[Bill R via AccessMonster.com]

We have had a recurring problem here where the qa testers have failed to
relink the development front end to the live back end before distribution,
resulting in users entering data into the development back end with a lot of
consternation on their part, as you can well imagine. I have successfully
created a small routine that runs when the db opens (it is in the onOpen
event of the startup form). I have tried putting the same code in the onClose
event of a hidden form that stays open as long as the db remains open, but
when I close the db using ctl F4 or clicking on the close button in the title
bar, the code doesn't run.

Any suggestions?

 

[Bill R via AccessMonster.com]

BTW, I get different results depending upon whether I open the db holding the
shift key and then open the startup form manually, or if I double click the
db icon and the startup form opens as a result of the startup options. In the
former scenario, when I close the db, I get no msgbox. In the latter scenario,
I get the msgbox. The problem is this msg is mostly for developers and qa
people, who typically open the db using the shift key.