VBA code to close form

[harleyskater]

I have a form with a command button. I just want it to close the form.
Any quick code?

 

[pbaldy]

Try the command button wizard, which will use the Close command in VBA.

 

[harleyskater]

it decided to use a macro : ) is there a way to have a macro and a vba code assigned to one command button?

Try the command button wizard, which will use the Close command in VBA.

 

[Ripley]

or if you want to do it yourself simlpy type:

Me.Close

If you want to quit the entire access application then i believe the code is:

Application.Quit

Its always advisible to throw up a message box to the user incase they have pressed the button by accident. So you'll need something like:

Private Sub YOURBUTTON_Click()
Dim x as Integer

x = MsgBox("Are you sure you want to quit?", 4, "Exit?")

'VbNo constant throws back #7
'VbYes constant throws back #6

If x = 7 Then
Exit Sub
Else
Application.Quit
'Or Me.Close
End If

End Sub

 

[pbaldy]

I forgot the wizards make embedded macros now. You can't have both, so I'd get rid of the embedded macro and put in code instead. That way, you can add whatever else you wanted.