I would like to dynamically change the database from which I pull records. I tried creating an ADO connection and recordset (rs) and used the following code to link the "new" table to the report:
Report.Database.SetDataSource rs
This, however, does not appear to work. The report is still pulling records from the original database.
Report.Database.SetDataSource rs
This, however, does not appear to work. The report is still pulling records from the original database.