Thanks for your reply, that worked perfectly.

I still don't really have a good reference to what objects are ADODB and
what are DAO. Is there a good reference out there?

Thanks,
David

"Allen Browne" wrote:

By definition, the form's RecordsetClone set is just a copy of the records
in the form, why not apply the filter directly to the form:
frm.Filter = "TO_INVOICE = -1"
frm.FilterOn = True

Depending on the data source for the form, you may also find that the form's
RecordsetClone is actually a DAO recordset, in which case assigning it to an
ADO recordset is not likely to work.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"dp" wrote in message
...
Hi everyone,

I am having a strange problem with trying pass a filter to a
recordsetclone
Here is my code::::

Dim invDetailRS As ADODB.Recordset

Dim rsClone As Recordset
Set rsClone = frm.RecordsetClone
rsClone.Filter = "TO_INVOICE = -1 "

it seems to ignore any filter I pass to it.

Anybody tried this before?
Thanks,David