DoCmd.Close problem

[taeratrin]

Hello,
I am just starting to learn VBA (have a bit of experience in VB.net), and am having problems right off the bat. Currently, I have created a user form with a single button whose sole purpose is to close the form. The code to do this is as follows:

Private Sub CBClose_Click()

    DoCmd.Close acForm, Me.Name

End Sub

This is the entirety of the code so far. Now, when I click the button to close the form, I receive an error stating "Object Required" (debug points to the DoCmd.Close line). After googling the problem, every other occurrence I found had to do with something not applicable to my current problem. Does anyone have any ideas as to why this is happening?

[Chrissy]

Private Sub CBClose_Click()
 
    Unload acForm
 
End Sub

(Assuming acForm is the form name)

[taeratrin]

Using the code you provided (modified to reflect the actual form name), I now receive a "Can't load or unload this object" error

[Chrissy]

Is CBClose the name of a command button on the form?

[taeratrin]

Yes.

[Chrissy]

Can you post the file?

[taeratrin]

Attached.

[Chrissy]

The should be exactly like this... (you had parenthesis around the form name)

Private Sub CBClose_Click()
 
    Unload UserForm1
 
End Sub

[taeratrin]

Thanks, that worked. I was thrown off by the intellisense.

[MarkWalsh]

You could also use:

Private Sub CBClose_Click()
    Unload Me
End Sub

This way, you don't have to edit the code if you change the name of the form, or use the code in a different form.