Unload the Mother Form

[slimimi]

Hi there - using excel 2003.

I have this simple code for a command button on an autoform.
As you can see - when the user clicks on the button it opens the frmPasswordSAVE

Private Sub cmdMODIFYtemplate_Click()
'Opens Password Checker which is frmPasswordSAVE
    frmPasswordSAVE.Show
    End Sub

Here is the code for the frmPasswordSAVE that i have to check for password entry

Private Sub cmdPASSok_Click()
    'Password Checker
    If Me.txtPASSWORD.Value <> "hundred" Then
        MsgBox "Incorrect Password", vbExclamation
        Me.txtPASSWORD.SetFocus
        Exit Sub
    End If
    If Me.txtPASSWORD.Value = "hundred" Then
        MsgBox "Correct Password"
    End If
        Unload Me
                    
    End Sub

As you can see - when you click the OK button - it checks the password and, if correct, unloads this form.

I would also like to unload the Mother form too which is called frmSAVElog

I tried entering this at the end :

unload frmSAVElog

but it did not work.

Any suggestions please?

 

[xenou]

I'm not sure here but I think you'd want to arrange the steps so that:

1) first you unload "other forms",
2) then you unload the current form.

It depends a bit on where you code is. If its in the form class, then once you unload the form ("Unload Me") then I'm not quite sure the code can finish any further instructions in the form (you've just destroyed the object).

In general, maybe put your code as much as possible in a standard module, so you don't lose instructions in the form objects - use the forms to get information and interact with the user, use standard modules to handle the program flow and processing.

I am not an expert on form applications - don't take my word for anything here.