Object doesn't support this property or method

  • Thread starter Thread starter Pierre de Beer
  • Start date Start date
P

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
 
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
 
Back
Top