Module to run a macro

  • Thread starter Thread starter mccallen60
  • Start date Start date
M

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
 
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
 
Back
Top