Is it possible to set the recordsource of a report to data stored in a recordset created in the reports on open event (Access 2000/ADO)?

I know that you can have me.recordsource = rs.Source.

But the recordset is actually populated from an external database table that isn't linked and the underlying SQL obviously populates from the Current project.connection.

Any help or work around would be really appreciated