Unload

[Deju]

How can I trigger an unload event of a form, when I change a combobox?

Thanks

In the combo1_click or change events, put this:

Unload Me

[Deju]

This doesn't work

This error is create:

Unload in the change/click or dropdown event of the
combobox doesn 't work. This is not allowed.


Isn't there an other solution?

[Jop]

maybe this isn't the most elegant way but:

Private Sub Combo1_click()
'Call our home-made function to Unload the form
Call Unloadme
End Sub

Private Sub Unloadme()
'Really Unload me now :)
Unload Me
End Sub

Hope it worked

You should also set the form to nothing.

Unload Me
Set Form1 = Nothing
End