Member Avatar for Carlo Miguel

whats wrong with this.. its not working!
Set rs = New ADODB.Recordset
rs.Open "select * from Personal inner join Company on Personal.CompanyID = Company.ID", conn, adOpenKeyset, adLockOptimistic
rs.Filter = "FirstName LIKE '" & searchtxt.Text & "'"

  • 3 Contributors
  • 3 Replies
  • 63 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by kennethjohn.esada
Member Avatar for Carlo Miguel

is there any one who can help me?

Member Avatar for Reverend Jim

That looks like the correct syntax. What does your recordset look like? Is the field name correct? What is the value of searchtxt.Text?

Member Avatar for kennethjohn.esada

it is adlockbatchoptimistic not adlockoptimistic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.