How do I suppress further database error messages...

[goddess_spanky]

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
goddess_spanky@hotmail.com

[Iouri]

DId you try On Error Goto 0 ?

Iouri Boutchkine
iouri@hotsheet.com

[goddess_spanky]

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

~goddess
goddess_spanky@hotmail.com

[Cimperiali]

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

[bhanuprakash]

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.