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

So in MYError_CausesAnError, you place you code that could throw up errors. In MYError_CausesAnError you handle your errors, i.e. do nothing, print a message to user, offer other options.

Hope this helps
David