Close button

How do you change the behaviour of the close buttons?

I want to bring up "Do you want to save changes to file?" dialog box with the yes, no & cancel options. If yes has been selected, then there will be data printed to a particular file and form unloaded.

What do you want them to do? Why is the more important question?

What do you want them to do? Why is the more important question?

I want to bring up "Do you want to save changes to file?" dialog box with the yes, no & cancel options. If yes has been selected, then there will be data printed to a particular file and form unloaded.

i understand you want to decide if the form unloads or not, ok, for this you have to code the Form_QueryUnload event
then you take the returned values from the MsgBox and if "Cancel" is pressed then set the Cancel parameter to any number different form 0 and it won't close your application

i understand you want to decide if the form unloads or not, ok, for this you have to code the Form_QueryUnload event
then you take the returned values from the MsgBox and if "Cancel" is pressed then set the Cancel parameter to any number different form 0 and it won't close your application

Can you explain the parameters for QueryUnload

different possibilities ase something to the extent of:

Private Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer)
msgbox "Save?", vbYesNoCancel, "Save?"
If vbYes Then
'Do something
ElseIf vbNo then
'Do something else
ElseIf vbCancel then
'Something else yet again
End If
End Sub

the parameters (as blue dragon posted early) are Cancel and UnloadMode, cancel tell whether the application closes or not, and UnloadMode tells you the mode that the application is closing by.

it maybe by closing it form the toolbar, or by the "x" button on the title bar, etc. You'll have to look out in MSDN yourself