Here is the code for checking if there is already an instance of an application running:
------------------------------------
Option Compare Database
Option Explicit
Private Const SW_HIDE = 0
Private Const SW_SHOWNORMAL = 1
Private Const SW_NORMAL = 1
Private Const SW_SHOWMINIMIZED = 2...
You could move your record update code to the OnClose event of the form. Ask the user if they wish to save the changes and if so write the changes to the database otherwise just close the form.
Kunjal
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.