Using a RecordsetClone for a Report Recordsource?

[Craig]

I have some forms were the users are able to use a filter-by-selection,sort
either by AZ-ZA. The users then want to see the results in the report exactly
as they are on the form. Would using the forms recordsetclone be the answer
to this.. and assign it the the reports recordsource? Would the coding look
like:

Reports("ReportName").Recordsource=Forms("FormName").RecordsetClone

Thanks.

 

[George Nicholson]

afaik, the recordsource property requires text (table name, query name, sql
string). You can't pass it a recordset object, it won't know what to do with
it.

Never tried it myself, but you can try using the Recordset property instead:

Reports("ReportName").Recordset=Forms("FormName").RecordsetClone

HTH,

 

[Craig]

I tried that method also, but with no luck. I'll just take that menubar
option out. Thanks for the input.