Compile Screen Shot
Writing VBA in Access (and other Office applications) is often required to add functionality to your application.
Every module should include "Option Explicit" in its General Declarations section. This will catch some errors as you type your code.
To test your code for syntax errors, select Debug->Compile ... If there are errors, a Compile Error dialog box will open and point to your problem code. The error message will provide some additional details.
|Learn how to create a multiple value crosstab query without creating multiple crosstabs.