ACC95: Opening Multiple Instances of Report Binds Data Too Soon

MORE INFORMATION

When a report is opened from the Database window, the OnOpen event changes the record source to another table . When an additional report instance is called from a function, like the one below, an error occurs: This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the programming tools provided with Microsoft Access. For more information about Visual Basic for Applications, please refer to the "Building Applications with Microsoft Access for Windows 95" manual.

Steps to Reproduce Problem

1. Open the sample database Northwind.mdb
2. Create a copy of the Employees table, and then save it as 2ndEmployees.
3. Edit the data for the 2ndEmployees table (to distinguish it from the first copy).
4. Using the AutoReport Wizard, create a new report based on the Employees table, and save it as MyReport.
5. Open the report, MyReport, in Design view and from the OnOpen event, change the report's RecordSource property as follows:

          Private Sub Report_Open(Cancel As Integer)
              Me.RecordSource = "2ndEmployees"
          End Sub
   						

6. Close and save the report.
7. In a new module create the following function to open a new instance of the report:

         Public Function CreateNewReportInstance()
            Static r As Report
            Set r = New Report_MyReport
            r.Visible = True
         End Function

8. Run the function from the Debug Window and note that the error message occurs.