How to catch oracle exception error

[nvrwrkn]

Got an oracle connect string tied to a form with user & pass. Works fine with correct credentials but with incorrect creds the code stops and shows the debug error of invald user/pass.



Trying to catch the error before the debugger comes up but nothing after the connection runs because if the connection can't be made the debugger starts and won't hit the errhandler code.

How can I get connect errors trapped and gotod? In other words, how can I look for this error and take it before the debugger?

[rpeare]

ON ERROR GOT ERRHANDLER 'at the beginning of your code'

'the rest of your code here

'this would be the at the very end of the code on your button
ERRHANDLER:
 debug.print err.number & " " & err.description
If err.number = 0000 'insert the error number you're getting in the debug statement here
   msgbox "OMG PICK A REAL NAME AND PW"
else
   'remaining error handling steps
endif

[nvrwrkn]

right.... gottit working now. Thanks sir!