error code 0

[Guest]

I am using an update SQL statement to update a field on one of my tables.
Everything appears to go well. Field gets updated, then it generates an
error code 0 in my error handler right after the update. What gives ?

 

[Allen Browne]

You forgot to add the:
Exit Sub
above the error handler code.

 

[Guest]

You are ABSOLUTELY right. I have written thousands of VB6 subs and
functions. I can't believe I left this out of this particular subroutine and
did not catch it. MY BAD. Thanks again..... Not necessarily correct, but
sometimes two pairs of eyes are better than one. Thanks Allen.... (Damn I
feel dumb).... :-(

 

[Allen Browne]

sometimes two pairs of eyes are better than one. (Damn I feel dumb)....
:-(

Hey, don't feel too bad.

How do you think I knew what the problem was?