ON ERROR GOTO not working (1 Viewer)

CALV

Registered User.
Local time
Today, 20:19
Joined
Apr 25, 2001
Messages
74
Hi all,

Access2000

For some reason, on error goto doesnt work, it just breaks with an error rather then carrying out the GOTO, does anyone have any suggestions? I can stop it TOTALLY by removing the tick in startup/use special keys but I dont what that !! has anyone any suggestions?
 

cpod

Registered User.
Local time
Today, 15:19
Joined
Nov 7, 2001
Messages
107
The error handler can only handle one error at a time.

Are you clearing the error handler by executing a Resume, Exit Sub, Exit Function, or Exit Property statement? If the error handler is not cleared by running one of these statements before another error is encountered then that error will not be handled.
 

anna the third

Registered User.
Local time
Today, 20:19
Joined
Sep 17, 2001
Messages
14
In the VBA interface
go to tools>options
select the "GENERAL" tab
under "ERROR TRAPPING"
see if "BREAK ON ALL ERRORS ISN'T CHECKED"

anna
 

CALV

Registered User.
Local time
Today, 20:19
Joined
Apr 25, 2001
Messages
74
Thanks for the replies, unfortunately Im off sick now so cant test it- it works fine here so the code is fine, I'll check for the tick on monday.
 

CALV

Registered User.
Local time
Today, 20:19
Joined
Apr 25, 2001
Messages
74
Thanks a lot, it was the break on all errors that was causing it.
 

Users who are viewing this thread

Top Bottom