Dynamically change object in Access 2007 Report
Posted on 2011-05-09
Found out that in Access 2003, a report's TEXT boxes control source and other settings CANNOT be changed by using code inside the report - it must be in a function
I could do this in Access 2003, but doesn't seem to work with Access 2007.
Before the report "Summary - pg1" is opened, I call the following function:
Reports![Summary - pg1]![Text222].ControlSource = "='For: ' & town"
Now, I get a error: Run-Time error '2451'
The report name 'Summary - pg1' you entered is misspelled or refers to a report that isn't open or doesn't exist.
How can I programmatically change a report's textbox's ControlSource WITHOUT opening it?