Edit a macro in Access 2010

bmorriso99
bmorriso99 used Ask the Experts™
on
I have a form that has a few buttons on it and one button says it is running a macro. I am new to Access 2010. I cannot find the macro. I need to see what it is doing.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Go into design mode on the form, then right click on the button and select properties.  On the properties form that appears click on the Events tab and then click the "..." button next to the on-click event.  That should bring up the macro code the button uses when it is clicked.

Author

Commented:
Thank-you - that is much further than I was able to get on my own!

I got a window under 'macro tools'  that has
RunMacro
           Macro Name: My_AutoExec
           Repeat Count
         Repeat Expression
    +   Add New Action


I don't see any code though.... what am I doing wrong?
Commented:
Ok you can close that window.  You're looking for the saved macro named My_Autoexec, so on the left side of the screen there should be a navigation bar (if there isn't,, press F11)

click on the bar and select "Macros"
you should see the My_AutoExec macro

Right click on it and select design mode
That will show you the macro code.

Author

Commented:
Quick response with perfect answer!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial