advanced micorosoft access training - VBA Access

Hi Tim
I trust that you found your Access VBA course useful. To trap errors in VBA, you need to use something known as Error handling. See below for an example:

Function MayCauseAnError()

    ' Enable error handler.

    On Error GoTo MYError_CausesAnError

    .            ' Include  your code here that may cause errors.

    .

    .



MYError_CausesAnError:

    .            ' code here to handle error, e.g print message to user

    .

    .

End Function