Referencing a report text box from VBA code on a form
Posted on 2008-10-26
I have a form that, when a button is clicked, runs code that opens a report and then loops through each record (setting a filter each time on the report) and generates a PDF file from the filtered report for each record. For each record, I need to insert some values from the report into another table.
Whenever I try to reference any of the text boxes on the report, I get an error with text similar to "You are referencing a property that has no value." Can anyone tell me how I can access the report text boxes?