while vba userforms have an event
Code:
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