Data Report Help

Is there any way to use an SQL statement to populate a data report using DAO instead of ADO? Just wondering because i have used DAO in my entire project except the small piece of ADO code used to populate the data report. Any help would be greatly appreciated.

All the Data Report requires is a Recordset. It doesn't care if it was created with DAO or ADO.

can you give an example of doing a data report without a data environment using dao?

anyone?!?

Did you search the forum? There are many examples(some even by me...)

Did you search the forum? There are many examples(some even by me...)

I checked all your submissions and could not find one that dealt with doing a data report in DAO rather than ADO. Could ya point me in its direction?

My mistake. I believe DataReport is only ADO aware.