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
This is how I am doing it...
With appAccess.DoCmd
.RunMacro "ApHistry"
.RunSQL "UPDATE APHistory SET..... "
.OpenReport "Aphistory", acViewPreview, , strACCond
.Maximize
End With
John