<div>
err.. That should have been<br />
<br />
&nbsp; With rs<br />
&nbsp; &nbsp; &nbsp; &nbsp; .Filter = MyFilter<br />
&nbsp; &nbsp; &nbsp; &nbsp; Set rs = .OpenRecordset<br />
&nbsp; &nbsp; End With
</div>


err.. That should have been

  With rs
        .Filter = MyFilter
        Set rs = .OpenRecordset
    End With

<div>
there is no FilterOn<br />
<br />
newRS.Filter = MyFilter '''turns on a filter<br />
newRS.Filter = 0 ''turns off the filter
</div>


there is no FilterOn

newRS.Filter = MyFilter '''turns on a filter
newRS.Filter = 0 ''turns off the filter

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


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.
    End If

Recordset.clone help

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.