Passing Parameters to Macros from VB?

[vbjohn]

How can I run a macro in VB that the macro asks for a parameter. How could I pass along the parameter to the macro?

This is how I am doing it...

With appAccess.DoCmd
.RunMacro "ApHistry"
.RunSQL "UPDATE APHistory SET..... "
.OpenReport "Aphistory", acViewPreview, , strACCond
.Maximize
End With


John

 

[Peter D]

I don't know if there's a way to do that. I recommend that you consider converting the macro to VBA code.

Hope this helps,

 

[Mile-O]

Macros don't ask for parameters; queries do!

 

[vbjohn]

but you know what i meant. when the macro is ran the query inside the macro is asking for a parameter. How could I pass that parameter for that query?

john-