I received a great question today from Norm. To paraphrase, he says he is using Access 2007 and whenever he creates a button using the Command Button Wizard (something like open a form, find a record, etc.) the button creates an Embedded Macro for him, which he doesn't want. He wants VBA so he can edit it.

Unfortunately, if you're using the Command Button Wizard, that's the default setting, and as far as I can tell, the ONLY setting for the Wizard. You can force Access to give you the VBA editor if you're making your OWN buttons, but changing the setting under File > Options > Object Designers > Always Use Event Procedures. This, however, doesn't change the Wizard. The Wizard will still give you an embedded macro.

There is a fix, however. When you're all done creating your Wizard-based buttons, in Form Design mode, click on the Design Tab and in the Tools section you'll see an option that says "Convert Form's Macros to Visual Basic." Click on that and Access will change ALL of the embedded macros in the form to VBA for you.

Easy enough?