How to call a macro using VBA in Access2000

Hi All,

I have a comand button on a form in an access 2000 database. Now using VBA I want to call a macro also residing in the same access database. Can anyone please help me with the correct syntax.

Thanks

You can use the DoCmd objects RunMacro method.

VB Code:

DoCmd.RunMacro "MyMacro"

Works fine. Thanks alot for your help.

No prob.

Since you are a newer member, usually we Resolve our threads when we get
them answered. This is like a courtesy to other members so they dont spend
allot of time reading long threads that alread solved. I have directions in my
signature on how to do it. ;)

Later :)