Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    254
    Thanks
    0
    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
    rst.Close
    End Sub

  2. #2
    DAW
    Guest

    Re: Find Method with ADO

    rst.close should say rs.close

    Dave.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •