Hello to all,
My issue is i have a small process wrapped in an error handler which does the job it needs to. However once the error has been corrected it does not continue.
Code:
On Error GoTo errorname
Dim myStr As String
Dim NameSplit As String
Dim myStr1 As String
NameSplit = Me.EmployeeName.Value
myStr = Split(NameSplit, " ")(1)
myStr1 = Split(NameSplit, " ")(0)
Me.LastNameLabel.Caption = myStr
Me.FirstNameLabel.Caption = myStr1
errorname:
Me.ErrorLabel.Caption = "Please Input Employee Name In This Format ""First Last"""
Me.EmployeeName.BackColor = vbRed
Err.Clear
Exit Sub
so if someone inputs : "John" it will throw an error and i will catch it and remind them that the name must be in "First Last" format.
It does this fine, however when i go back into the text box and add the last name it is still acting as if there is an error.
So my question is how do i fix this? I added the err.clear statement hoping it would clear it out but no such luck.
Any ideas?