Hi I want to open a form if the error occurs. Currently on error I get the standard access message, on debug the error is at the line i have highlighted
Either Open a form or customise the message but the code does not seem to get to Form_Load_Err. Sorry I'm not too flash on VBA so any help, I'm grateful
Private Sub Form_Load()
On Error GoTo Form_Load_Err
DoCmd.Close acForm, "frmExpired"
DoCmd.OpenForm "frmLogon", acNormal, "", "", , acNormal <<<Error Here
Form_Load_Exit:
Exit Sub
Form_Load_Err:
MsgBox Error$
Resume Form_Load_Exit
End Sub