How do I create a form object 1

[MalekTaus]

I am trying to create a sub procedure for cancel buttons across several forms.

The problem is that I need to be able to pass the form object to the procedure in order to unload the form.

Can anyone help?

 

[SkipVought]

Hi,

Check out the Forms collection.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[MalekTaus]

It was UserForm that I needed.

Thanks for the help and here is my oh so simple solution

Private Sub btnCancel_Click()
Call cancelButton(Me)
End Sub

Sub cancelButton(frm As UserForm)

Unload frm

End Sub

 

[cresbydotcom]

Form1.Show & Form1.Hide work for me - that way I can set values before it is visible. Or use the Activate/deactivate events to set things up.

 

[combo]

As long as you do not want to interact with the form you try to close, without calling external procedure:

Private Sub btnCancel_Click()
Unload Me
End Sub

combo