Closing 1 form closes both open forms

[jacko2401]

Hi

I have 1 main userform and I need to open another userform using a command button from within that 1st form. The 2nd userform appear right in front of the 1st userform. When the 2nd userform is closed either via VBA or clicking on X, it closes both forms.

Does anyone know why this happens and how I can make only the 2nd form close when it is finished with?

 

[mikerickson]

It would depend a lot on how the userform's are called or whether they are modeless.

One quick solution would be to .Hide the second userform rather than unloading it. (You can unload it in the first Userform's Terminate event.)

 

[jacko2401]

It would depend a lot on how the userform's are called or whether they are modeless.

One quick solution would be to .Hide the second userform rather than unloading it. (You can unload it in the first Userform's Terminate event.)

The 2 forms are called RegPlayers and FrmNumber2

The first form is opened from a command button on a worksheet by assigning a sub procedure:
Sub Main_Players()
RegPlayers.Show
End Sub

The first form has a command button on it that has the following sub procedure that opens the 2nd form:

Private Sub CmdDOBCalendar_Click()
FrmNumber2.Show
End Sub

When you close the 2nd form, the first form also closes. Any ideas to stop this?

 

[mikerickson]

I would put a break somewhere in FrmNumber2's code. and then step through its closing to see where RegPlayers is sending exicution after UF2 is closed.