Object doesn't support this property or method

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pierre de Beer - 31 May 2004 09:03 GMT

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

Reply to this Message

Igor V. Makeev - 31 May 2004 15:01 GMT

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

Reply to this Message