How do I suppress further database error messages...

I have an adodc control with an 'error' event handler (basically just a message box with the error specifics). once my event handler is complete however, I get a standard error message ( i guess generated by VB or the ODBC driver)
Is there a way to suppress this additional message box?

Thanks,

~goddess
[email protected]

DId you try On Error Goto 0 ?

Iouri Boutchkine
[email protected]

where would i put it? in the module with my custom error message or in the adodc control's error event?

~goddess
[email protected]

On ending the error handler routine, you should let vb leave it with a Resume instruction:
on error goto myErrHanlder
....
Exit_From_Here:
...
exit sub
myErrHanlder:
'do the stuff...
...
Resume Exit_From_Here
end sub

Special thanks to Lothar "the Great" Haensler, Tom Archer, Chris Eastwood, TCartwright, Bruno Paris, Dr_Micahel
and all the other wonderful people who made and make Codeguru a great place.
Come back soon, you Gurus.

The Rater

first time when you get the error please debug and in debug mode type err.number then you get the error number in code write "on error goto xxx"

and in xxx portion you write the code what the system should do if this problem is occured either you reconnect your connect of you simply exit out of the system.

you can also use on error resume next state ment which will discard all teh error messages occured.