Change Caption of a Report with a MAcro

[jordivi]

Hi all,
I want to print (using Acrobat Distiller) an Access Report, saving it every time with a different name. The proper name to use is in a Form.

I'm trying to change tha Caption value of a Report using a Macro and setting as new Caption the name read in a form.
I use the 'SetValue' action in the Macro:

Element: [Reports]![ReportName].[Caption]
Espression: =[forms]![formname].[name]

But when I run the Macro Access gives me a negative response: it's not a 'OLE Object'

Thanks a lot
jordivi

 

[pdldavis]

Hi, You might try using Vb rather than using a macro on the reports Open Event. Something like:
me!YourLblCaption.Caption = forms!yourform.yoursource