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 & "'"
Carlo Miguel
0
Newbie Poster
Recommended Answers
Jump to PostThat looks like the correct syntax. What does your recordset look like? Is the field name correct? What is the value of searchtxt.Text?
All 3 Replies
Carlo Miguel
0
Newbie Poster
is there any one who can help me?
Reverend Jim
4,780
Hi, I'm Jim, one of DaniWeb's moderators.
Moderator
Featured Poster
That looks like the correct syntax. What does your recordset look like? Is the field name correct? What is the value of searchtxt.Text?
kennethjohn.esada
0
Newbie Poster
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.