In Microsoft Access, I am using a Form to set up parameters and run reports from a single database. One of the parameters is a report title.
Within the Form, I have set up VBA code for running the reports. I am using a memory variable (strReportName) to store the title for each report, rather than having to create a new report object each time I want to use a new title. Within the Form, at the very top of the code window under "Option Compare Database", I am using the following code to declare strReportName:
Dim strReportName As String
Within the Report, I have set up a text box object to store the title. Within the properties for this text box, under data, I have set the control source to read:
My problem is this: the title being stored in strReportName is not making it's way from the Form to the Report, and thus the Report is not printing out any titles. How do I solve this?
Microsoft Access 2007
July 31, 2011 4:50 AM
March 31, 2012 7:34 PM