Module to run a macro

[mccallen60]

Hello,
I hoping someone can help me with a module question. I have MS Access 2003.
My database has a macro called "Process Data". I want to create a module that
gives me a message box stating "Links Verified?". When the user clicks OK,
the module will run the "Process Data" macro. When user clicks Cancel, the
"Process Data" macro will not run and the message box closes. I am very new
to VBA, so I was hoping someone can provide me this code.
Please let me know if I need to provide you with more information.
Thanks in advance.
Kevin

 

[Daryl S]

Kevin -

In the OnClick event of the button you create, put this in:

If MsgBox("Links Verified? OK to Process Data?", vbOKCancel) = vbOK Then
DoCmd.RunMacro "Process Data"
End If

 

[mccallen60]

Daryl,
That worked like a charm! Thank you very much.
Kevin