How to open Recordset and send the ouput to a report?

[neerja khattar]

open a recordset using ado or dao and send the result to a report.

I tried using .name property but it doesnt accpet more than 80 characters

Report_open_event
me.recordsource = rs5.name
end

this doesnt work with my big query having lots of join

[NeoPa]

If you check out the Help for a report's RecordSource property, you'll find it doesn't support working with recordsets. A recordset is an object in your VBA code, whereas the report needs either the name of a recordset object (EG. a saved TableDef or QueryDef object from an Access database) or the SQL in a string.