How to save the information in the form if it accidentally gets closed?

[aaromic2000]

Hi,

I have a form which has a list box and text box with employee details. The form is used to track day to day activities. The form should be opened for 9 hours continuously. But automatic system restart or mandatory reboot in the mid of the working hours makes it difficult to save the details. How to do this using VBA. I've tried "DoCmd.Runcommand acCmdSaveRecord" in the code but of no use.

Any suggestions?

[westconn1]

while vba userforms have an event

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
   'code here will run if form tries to close
End Sub

i do not know if access forms have a similar event