Pass Parameter from Report (VBA to Macro) Access 2007

[accessles]

Hi,
I have a macro called mcrRightClickItems. I have an Open Report with a
Report Name which I filled in with "Report2". My question is how to pass from
VBA to the Report Name different Reports so I don't have to hard code
different macros for my report.

I have shortcut menu bar which has the name of the macro to run.

I hope this makes sense.

Thanks,

Les

 

[Tom van Stiphout]

Can't you use the RunCode action and do most of your programming in
VBA?

-Tom.
Microsoft Access MVP

 

[accessles via AccessMonster.com]

Tom,
Thanks for the tip. It works great

Can't you use the RunCode action and do most of your programming in
VBA?

-Tom.
Microsoft Access MVP

Hi,
I have a macro called mcrRightClickItems. I have an Open Report with a

[quoted text clipped - 9 lines]

Les