Code to make form unload itself

[sphinney]

Hello, All.

I'm embarrassed to even ask this question because it seems like such a simple thing. But, here it is …

What is the code to make a form unload itself?

I have a form with a number of controls and buttons on it. When the user clicks the button ‘A’, I want the form to close itself. I’ve tried using the “Unload” statement, but Access 2002 doesn’t like it. I get a #361 run-time error.

Private Sub Button_A_Click()
Unload Me
Exit Sub

Can anyone toss me a bone on this one? I’m sick of spinning my wheels on this.

Humbly,
Scott

[Denburt]

You can close the form using the following method.

Private Sub Button_A_Click()
DoCmd.Close
exit sub

If you have code that you would like to run in the unload event then you can call the unload event using the following:

Private Sub Button_A_Click() 
Form_Unload False
exit sub

[sphinney]

Ugh! I knew it was going to be something simple!

Thanks for helping!

Scott

[Denburt]

It's my pleasure! :)