How to detect if user clicked the close button on a form...

[JONeill]

New to Access programming and I'm trying to find an equivalent Query_Close event to detect if the user hit the x in the upper right corner of a form. Found out how to disable it but not how to detect if it has been clicked. I'm sure it's pretty simple but I'm just not finding it out there.

 

[Yongle]

EXCEL - I know you do not want this, but someone may find it useful

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
'detect if clicked
    If CloseMode = 0 Then MsgBox "User clicked the X"""
'disable
    If CloseMode <> 1 Then Cancel = 1
    Me.Caption = "Click on button to close"
End Sub

ACCESS - I have not tested it but there appears to be a solution here
https://social.msdn.microsoft.com/F...-quotxquot-clicked-on-a-form-?forum=accessdev

 

[JONeill]

I think this does the trick...

Private closeFlag as Boolean


Private Sub cmdClose_Click()
      closeFlag = True
      DoCmd.Close
End Sub



Private Sub Form_Unload(Cancel as Integer)
 
 If closeFlag then
  MsgBox "Close button was pressed."
 Else
  MsgBox "Something else closed the form."
 End If



End Sub

 

[JONeill]

That's assuming, of course, that the user did indeed close the form.