every procedure you write in Access VBA should have error handling. Keep error handling simple and easy to implement, with one basic copy-and-paste code block. Then do a few quick steps if necessary to adapt the error handling to your procedure:
Change Exit Function to Exit Sub if the procedure is a sub.
Add code to quietly absorb expected errors, if any.
Make sure you perform any necessary cleanup if an error occurs.
By following these error-handling guidelines, you'll build VBA code that is easier to debug and maintain, so you can focus on building great features into your application.