Object doesn't support this property or method

[Pierre de Beer]

Good Day

While using a sub form the code that is generated by
access displays this error message. "Object doesn't
support this property or method"

This is the code

Private Sub Combo40_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ID] = " & Str(Me![Combo40])
Me.Bookmark = rs.Bookmark
End Sub

I believe this is a active controle problem. What is the
best way to resolve this?

Thank You

Pierre

 

[Igor V. Makeev]

Hello, Pierre!
You wrote in message on Mon, 31 May 2004 01:03:40 -0700:

PdB> While using a sub form the code that is generated by
PdB> access displays this error message. "Object doesn't
PdB> support this property or method"

If your subform is based on MSSQL, the data type of the RecordsetClone is
ADODB.Recordset.
ADODB.Recordset not supports the FindFirst method. You should use the Find
method.

With best regards, Igor.
ICQ: 111469481