Form unload error: 361. Why?

[javanic]

Hi.

In Excel VBA, I have this code:

Private Sub cmdExit_Click()
   Unload frmMyForm
End Sub

It works in Excel. But in Access, I have the identical code, and it doesn't work. It gives me Run Time Error 361 - Can't load or unload this object.

Thanks for you help in advance,


- javanic -

 

[BillPower]

In Access it should be:

Private Sub cmdExit_Click()
Docmd.Close acForm, frmMyForm
End Sub

Bill

 

[javanic]

Thanks, billpower.

With the addition of quotes around the form name, your code worked.

Private Sub cmdExit_Click()
   Docmd.Close acForm, &quot;frmMyForm&quot;  <--- quotes needed
End Sub

- javanic -

 

[BillPower]

Hi javanic,

Not meaning to be pedantic myself, but I didn't know how you were setting the variable frmMyForm (and still don't)when I made my suggestion. In future maybe you can supply full code when seeking help. frmMyForm set in the manner below doesn't need quotes, placed in the On Click event of a button would close the form containing the button.

Dim frmMyForm As String
frmMyForm = Me.Name
DoCmd.Close acForm, frmMyForm '<--- quotes not needed

Glad it worked in a round about way.

Bill

 

[javanic]

Thanks again, billpower.

I'm learning more each time. When I first tried the code you gave me, Access still complained. I dug deeper and caught sight of the word &quot;string&quot; in help. I was using the actual form name, not a variable, as I would in Excel VBA. Apparently in Access, and with the DoCmd, it is looking for the name of the form in a string formatted variable.

What I showed in the first post *was* the full code--as I had incorrectly written it, of course.


- javanic -