Access 2007 FAQ
For click events is there a way for the wizard to create code rather than an embedded macro?
In Access 2007 if you use the wizard to build your button, Access creates an embedded macro attached to the control. This is a departure from previous version where Access wrote VBA code behind the click event.
There is no setting that you can change to force Access 2007 to write VBA code instead of an embedded macro. However, this only applies to databases in the newer ACCDB file format. If you're using the MDB file format, Access does create VBA code when you use the button wizard.
See more tips and tricks like this in our book: Microsoft Office Access 2007 Inside Out
Back to FAQ main page