Populate Report or Query from ADO Recordset

Hello,
I am modifying existing Access application that has number of reports. The
current version of the application uses pass-through queries to get data
from SQL Server database, reports use those queries as their data source.
However the new version which I am developing wont have access to SQL Server
db, but rather will use COM Component will return ADO recordset.

My question how can Report or Query be filled with ADO Recordset in MS
Access application.

Thank you for your help!

Hi Lenn,

Take a look at:
http://www.programmingmsaccess.com/S...tToAReport.htm
--
hth,
SusanV

"Lenn" wrote in message
...
Hello,
I am modifying existing Access application that has number of reports. The
current version of the application uses pass-through queries to get data
from SQL Server database, reports use those queries as their data source.
However the new version which I am developing wont have access to SQL
Server db, but rather will use COM Component will return ADO recordset.

My question how can Report or Query be filled with ADO Recordset in MS
Access application.

Thank you for your help!