Why an Error Handler?

  • Thread starter Thread starter Chaplain Pruiett
  • Start date Start date
C

Chaplain Pruiett

I noticed that when Access generates a function or
subroutine it puts the following in the routine:

On Error GoTo Err_CNPR

Exit_CNPR:
Exit Function

Err_CNPR:
MsgBox Err.DESCRIPTION
Resume Exit_CNPR

What does this really buy me? It seems that when an error
occurs the same thing happens (I get an unhelpful MsgBox)
whether I have this "error handler" or not. Thanks.
 
Chaplain said:
I noticed that when Access generates a function or
subroutine it puts the following in the routine:

On Error GoTo Err_CNPR

Exit_CNPR:
Exit Function

Err_CNPR:
MsgBox Err.DESCRIPTION
Resume Exit_CNPR

What does this really buy me? It seems that when an error
occurs the same thing happens (I get an unhelpful MsgBox)
whether I have this "error handler" or not. Thanks.
Click to expand...


Please don't post the same question mulltiple times, it
makes it difficult to keep track of progress towards an
acceptable answer.

Check back to your earlier post.
 
Back
Top