DoCmd.Close problem

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:

Code:

---

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?

vb Code:

Private Sub CBClose_Click()
 
    Unload acForm
 
End Sub

(Assuming acForm is the form name)

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

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

Yes.

Can you post the file?

Attached.

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

vb Code:

Private Sub CBClose_Click()
 
    Unload UserForm1
 
End Sub

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

You could also use:

vb Code:

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.