Error Code assistance

VS6 SP5,

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"
          Case Else
          MsgBox "You are required to select a manager to send the request to!"
End Select
err5:
Err.Clear

The Err.Clear above still alows the rest of my code to run...

More code that send email confirmation....
ittechie100Asked:
Who is Participating?
 
leclairmConnect With a Mentor Commented:
Actually something more like :

Select Case Combo2.Text
          Case Is = "user1", "user2", "user3", "user4"
          Case Else
          MsgBox "You are required to select a manager to send the request to!"
          exit sub ' or exit function
End Select
0
 
leclairmCommented:
Have you tried putting an "exit sub" in the error handler??
0
 
ittechie100Author Commented:
Thank you..Sorry for something so small, however I've never taken any programming classes, learning as I go...

Thanks...
0
 
leclairmCommented:
Thanks for the points and good luck with your learning process.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.