Cancel Unload

[corydg]

Here's what I've got

Private Sub Form_Unload(Cancel As Integer)
Cancel = True
End Sub

Problem is, it closes any child forms even though it doesn't close the main form.

Is there a solution?

cory

[pnish]

Try setting Cancel = True in the form's QueryUnload event instead.

[baja_yu]

What pnish said will work but you will have to do some 'IFing' or it will be impossible to close the application if you do only that.

[modpluz]

Welcome to the forums...

try this...

Private Sub Form_Unload(Cancel As Integer)
Cancel = 1 'Change True to 1
End Sub

[pnish]

try this...

Private Sub Form_Unload(Cancel As Integer)
Cancel = 1 'Change True to 1
End Sub

Cancel can be any non-zero value. So Cancel = 1 will work exactly the same as Cancel = True (True = -1). If you wanted you could make Cancel = 12345 and it would work.

As I posted earlier, the solution is move the code to the QueryUnload event.

[corydg]

Hey Guys,

Thanks for the help. It works great. I didn't even notice the QueryUnload event.

Thanks again,

Cory