Hi,
I am trying to refer to a parameter value on a report, to use as part of a filename.
Here is the code:
DoCmd.OpenReport "Projects", acViewPreview, , , , "NoGroup"
MyFileName = "Green Team Weekly Report - " & [Reports]![Projects].[Start Date] & ".pdf"
"Start Date" is the parameter name. But i am getting an error:
ms access cannot find the field "|"referred to in your expression
How is it possible at this point in the code to refer to this parameter value?
Thanks.