I'm doing a clone of a recordset using set newRS = me.recordset.clone. I'm then setting the filter for the cloned recordset which works fine. The problem occurs when I try to turn the filter on. I get an error message saying "Object doesn't support this property or method". Why am I able to set a filter for the cloned recordset but not turn the filter on? Is this possible and I'm just doing something wrong?
Set newRS = Me.Recordset.Clone
If newRS.RecordCount > 0 Then
MyBookMark = newRS.Bookmark
newRS.Filter = MyFilter
newRS.FilterOn = True 'Error thrown here.