Unload Me

[Jac Tremblay]

Hi,
I have a form loaded as Modal and on the Cancel Button event, I want it to
close (or unload).

Private Sub cmdAnnuler_Click()
MsgBox "me.Name = " & Me.Name ' To make sure it is the right one.
Unload Me
End Sub
I get an error:
Run-time error '361':
Can't load or unload this object

What is the problem?
Thanks

 

[Marshall Barton]

I have a form loaded as Modal and on the Cancel Button event, I want it to
close (or unload).

Private Sub cmdAnnuler_Click()
MsgBox "me.Name = " & Me.Name ' To make sure it is the right one.
Unload Me
End Sub
I get an error:
Run-time error '361':
Can't load or unload this object

You need to use the Close method with Access forms.

DoCmd.Close acForm, Me.Name, acSaveNo

Check VBA Help for details.