Error #0 and VB

I am getting an Error #0 msgbox when loading a form that is connecting to a SQL DB and getting Recordsets.  If I click ok, the form opens fine.

I cannot figure out why I'm getting this error?

Any ideas?

baddogiAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
RichWConnect With a Mentor Commented:
Look at the error handler in the form.

What is most likely happening is that an error is raised,  and the Error object is getting reset prior to displaying the error value.  

Check your error handling code.
0
 
amebaCommented:
You forgot "Exit Sub" or "Exit Function" before error label.

Sub SomeSub()
     On Error GoTo EH
     '...
     '...
     Exit Sub          '  <<<< this is missing
EH:
     ShowError
End Sub
0
 
RichWCommented:
ameba is correct.  That could also be it.
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.