VBA Code for buttons, Access 2010

[nchesebro]

Hello,



In using this new version of Access, I have found that when creating buttons, Access no longer uses vba codebehind to handle all the dirty work - rather, it seems Microsoft is forcing me to use the upgraded (and very nice I must say) Macro builder. This is fine for all the simple tasks, but what I have myself into is a little more complex than the Macro builder is ready to handle I think...

Before, when I created a button, it would put the code in VBA, not a Macro. I am trying to build the following button types:

Button 1 - Update a Field in a table, Save form, Close form
Button 2 - Update a field in a table, save form, new record
Button 3 - Update a field in a table, save form, print report, close form
... and so on and so forth.

I used to put 3 or 4 buttons on the form, then copy and paste the generated vba in the correct order in a single button, and delete the dummy buttons. But now it seems as the basic functions are built using an embedded macro, and when that is combined with VBA, Access must choose between one or the other, rendering my button useless.

Is there a setting in 2010 that will change the way buttons are created in that VBA is used by default instead of macros?

[RuralGuy]

Try:
File>Options>Object Designers>Form/Report design view>Always use event procedures

[nchesebro]

Thank You.

[RuralGuy]

Glad we could help.