Error Code assistance
Posted on 2006-07-14
Have a form that employees fill out and then click submit button to email the contents of their
request to a manager, problem is if they forget to select who there manager is from combo2.text
it errors out and they loose everything else in the form they have already entered...I need error
control that will stop in the event of an error and allow the user time to select a manager
and continue with the submit button....Please help..
On Error GoTo err5
Select Case Combo2.Text
Case Is = "user1", "user2", "user3", "user4"
MsgBox "You are required to select a manager to send the request to!"
The Err.Clear above still alows the rest of my code to run...
More code that send email confirmation....