I have done this several times with forms, however this is the first time I am attempting the implementation with a report. I am used to being able to dynamically setting the recordset when I am trying to connect to a data source external to the database.
When I attempt set the recordset of a report i get the following:
Run-time error '32585':
This feature is only available in an ADP.
Is my only option going to be to insert the recordset into a temp table?
This is the typical code I put into the OnOpen event:
dim db as Database
dim rs as DAO.Recordset2
set db = OpenDatabase("\\Server\Path\LegacyData.accdb")
set rs = db.openrecordset(SQL, dbopendynaset, _
set me.recordset = rs
set rs = nothing
set db = nothing