If no matches Reopen form after Msgbox

[LoveLearning]

Hi,

I currently have an unbound form I am using as a switchboard. When a button is pressed it loads a form asking for the user to enter their password (the swtichboard is then closed). If the correct password is entered the form opens to their details, when that form is closed, the swtichboard re-opens. I want an action that if the correct password is not used, then a msgbox lets them know and then the Switchboard they were at re-opens. So far I have the following code:
Private Sub Form_Open(Cancel As Integer)
If Me.Recordset.RecordCount = 0 Then
MsgBox "Incorrect Password!"
Cancel = True
End If
End Sub



This works well, but I am unsure how to write that after the msgbox I want the Switchboard to open. I tried to add "DoCmd.OpenForm frmSwitchMain" in various places, but I am unsure on the proper proceedure to do this.

[Rawb]

You would add it immediately after your MsgBox and before "Cancel = True".

Private Sub Form_Open(Cancel As Integer)
  If Me.Recordset.RecordCount = 0 Then
    MsgBox "Incorrect Password!"
    DoCmd.OpenForm "frmSwitchMain"
    Cancel = True
  End If
End Sub

[LoveLearning]

This is Perfect...Thank you so much for your effort.