view vba code from buttons (1 Viewer)

[maxmangion]

In Access 2007 when creating a button using the command button wizard, when I click on the ellipsis to view the code created, the Macro Builder is displayed, showing the actions that make up the embedded macro. Is there a way to view the vba code rather than the macro as it used to be in previous versions of Access?

Thank you

 

[RuralGuy]

Office Button>Access Options>Object Designers>Forms/Reports>Always use event procedures
Then OK your way back out.

 

[maxmangion]

thanks for your reply. Actually I had already ticked that option, but I am still getting the macro display instead of the code.

 

[RuralGuy]

If the embedded macro already exists then you will need to follow these directions to convert them. The event property sheet row has a ComboBox so select [Event Procedure] for future code.

 

[CEH]

2007 uses a lot more macros.... Unlike previous versions. You need to first "Convert macros to VBA" then you would be able to see the code. Sorry, I forget where that option is in 07....Only up to 03 on this machine... Maybe someone can give the path.

 

[maxmangion]

Thank you for your help.