Find method with ADO
I have a form with a blank combo box called CboCompany.
My code in the AFter update event does noit work,and i
receive the error “object required”.Where is my mistake?
ANy help will be reatly appreciated.The code is :
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
‘Open the connection
cn.Open “Provider=Microsoft.Jet.OLEDB.4.0;” & “Data Source= C:BEdb1.mdb;”
rs.Open “tblClients”, cn, adOpenKeyset, adLockOptimistic
rs.Find “[ClientID] = ” & CboCompany.Value
rst.Close
End Sub
