Results 1 to 2 of 2
Thread: Find Method with ADO
2001-02-19, 13:12 #1
- Join Date
- Jan 2001
- Thanked 0 Times in 0 Posts
Find Method with ADO
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
2001-02-19, 15:27 #2DAWGuest
Re: Find Method with ADO
rst.close should say rs.close