a button to run a macro

My MSAccess wizard is not working properly. I am trying to create a
button to run a macro. Can anyone tell me the SQL code that I can put
into the event procedure to make it happen?

Thanks!

PS: I am also trying to get a button to open a form and to run a report.

gzim...@linerlaw.com wrote:[color=blue]
> My MSAccess wizard is not working properly. I am trying to create a
> button to run a macro. Can anyone tell me the SQL code that I can[/color]
put[color=blue]
> into the event procedure to make it happen?
>
> Thanks!
>[/color]
Public Sub RunMyMacro()
DoCmd.RunMacro "MacroName"
End Sub


SQL code? That's for data/table manipulation...

Thanks, my novice nature show's through. But your thing worked.