I have a db that when forms are changed, one closes and the other opens.
I use the onOpen and onClose to run a series of queries.
I have an exit button that closes the screen and then quits the application.
This method has no effect on the onOpen/onClose queries, but if somebody Alt + F4, my queries don't have a chance to run and requests me to "Enter Parameter" before it eventually debugs. Any clues? I need these queries to run in order to maintain a log of all users whereabouts.
My query that I run records the user which is located on the active form. How can I prevent it from debugging when Alt + F4 is keyed? Alt + F4 shuts down the database before it can run the OnClose query. Any suggestions?