Calling a macro from form (button click)

[aas1611]

Hi all,

I have the next problem.

I have a macro, called let's say macro1. This macro opens a report (openReport).

On a form, I want to call this macro with a click of a button. Does anybody know (the command) how to this? I used

doCmd.RunMacro macro1

but it didn't work.

Please help! and Thanks!


Andre

 

[djwatts]

bring up the properties for the button then select the event tab. under the on_click field there should be a drop down to select the macro

 

[aas1611]

Hey, thanks! I never thought there existed a much easier way.

Not to push my luck, but, do you happen to know the answer of my other question (thread700-1179214)?

Andre