How to run Data macro using VBA Code.

[pritesharyan]

I try to run Data macro using VBA Code.


below image shows my question.
Please guide me.

Private Sub cmdRunDataMacro_Click()
   DoCmd.SetParameter "prmMetalID", Me.cmbMetal
   DoCmd.RunDataMacro "Metal.GetMetalParameter"
   DoCmd.SetProperty txtTestMetal, acPropertyValue, [ReturnVars]![retPrice]
End Sub

[cbende2]

I'm not to familiar with this.

However, you may want to try using Access's built in feature, "Convert Form's Macros to Visual Basic."

This will remove any user error when creating the macro in vba.

[nick404]

2nd line where you run macro looks funny.
I don't believe that is correct vb syntax/format.
try

DoCmd.RunMacro "MacroName", 1

Fill in your macro's name where it says. The 1 means it only runs once which I assume is what you want. If you want it to run more than once just change that number.

More info: https://msdn.microsoft.com/en-us/lib.../ff192075.aspx