Running a Sub Procedure

After writing a Sub procedure, you may want to test it. You can run a Sub procedure from within the Visual Basic Editor, but you might have to return to Access to view the results. If the Sub procedure is a long one, you can also click buttons to pause it or to stop it altogether.

Run a Sub Procedure

Click the Save button on the Database toolbar to save changes to the VBA project.

Enter a name for your module if requested .

Click anywhere within the Sub procedure that you want to run.

Click the Run Sub/User Form button on the Database toolbar.

If the Macros dialog box appears, select the macro you want to run, and then click Run.

Return to Access, if necessary, to view the results of your Sub procedure.

Did You Know?

You can rename a module . If you want to rename a module, select the module from the Project Explorer, and then enter a new name in the Name box, located in the Properties window.

You can run a procedure from the keyboard . You can also run a Sub procedure by pressing F5. If you need to halt the procedure, press the Ctrl and the Break keys simultaneously .