Macros are great for jump-starting an application, but they take you only so far; you need to turn to code for a more robust, powerful application. You can convert most macro commands to a method of the DoCmd object. Access 2000 includes an easy way to convert your macros so that you keep all the work you've done and move your macros over to VBA.
For more information on VBA commands and error handling, see these chapters:
Chapter 2, “Coding in Access 2000 with VBA,” gives a overview of using VBA in Access.
Chapter 7, "Handling Your Errors in Access with VBA," explains how to use error handling to make your applications more robust.
3.135.200.211