Recordsetclone

[Ascentient]

I have a created a recordsetclone of the data source of the form I am working on and it will not give me the .findfirst method.

The following is my code.

   Dim rs As Recordset
   Set rs = Me.RecordsetClone
   rs.FindFirst = "[Material] =" & """ & cboMaterialCode & """

I have used this method before (Not exactly the same but close.) and have not had this problem. What do I have setup incorrectly?

Ascent
~The only way to learn is live

 

[Ascentient]

Nevermind I found I had the "=" after the .FindFirst. I removed it and it works fine. (Also added the DAO. when declaring the recordset.)