Shortly after I posted my previous post I found the simple solution to what I wanted to do. The caption for the report is pulled from a field name on a form I have open. In the On Open event of the Report I used this format:
Me.Caption = Forms!FormName!FieldName
DBAMJA, will you please post your solution. I am currently looking for a solution to change the report's caption to the file name I want it to be saved as in the Report_Open Event. Thanks in advance.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.