Why an Error Handler?

[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.

 

[Marshall Barton]

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.

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.