Using Multiply form

[Roy Goldhammer]

Hello there

Is there a way to open the same form more then once?

 

[Marshall Barton]

Is there a way to open the same form more then once?

Yes. As long as the form has a code (class) module, you can
use this type of logic:

Dim aryForms(10) As Form
Dim intIndex As Integer

Public Sub OpenMyForm()
Dim frm As Form
Set frm = NEW Form_nameofform
frm.Visible = True
aryForms(intIndex) = frm
intIndex = intIndex + 1
End Sub

If you prefer, you can use a collection instead of an array,
just make sure its at the module level so it doesn't go out
of scope when the Sub exits.

You will probably need a way to manage the array entries so
you can reuse the ones that are no longer needed as copies
of the form are closed.

Note that the NEW syntax does not allow for any of the
argument options that you can use with the OpenForm method.

All this is the same as creating multiple instances of any
class you create.