macro running sub

[Joe C]

I wrote a macro to pull out reporting. How do I start the macro which is in module2 using the Macro screen area. All I see is runMacro which only allows me to run the macros built in the macro screen, and open module which allows me to open module2 but it does not run the macro.
Im very new to access, quite experianced in VBA in excel.
Thanks for any help.

 

[Corticus]

Hi,

Go into the VBA editor, and write your macro, but make it a function. In other words, instead of

sub procedure1()

, use

function procedure1()

Go to the macro tab (not the VBA editor). Select new. Select action|RunCode. Under function name type or select the name of the function you just created.

HTH,