Converting Recordsetclone property to RecordSource

[lldevel]

Hi,

Doe anyone know how to convert a datasheet's recordsetclone into a recordsource usable string? I want to allow the user to filter, sort, etc. the datasheet using the built in menus, then invoke a report based on that filtered recordset. The only way I know of is to set the report's recordssource, but it appears the filtered/sorted recordset is only available via the recordsetclone method from the datasheet? Any tips appreciated.

L

 

[Lozere]

Why put the same question in two forums??

I try to give you a solution in the Report forum.

 

[lldevel]

This went unanswered for several days, and I suspected it may be in the wrong forum.

LLdevel