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