Help on ADO.RS.FIND

How do I do a search on the recordset from a value inputed in a text box??
below is my example,  the way it is, it searchs for text17.text as the sitename.

please help

With Adodc3.Recordset
  .Find "SITE_NAME = 'TEXT17.text'"
   If Not .EOF Then
    'Record was found
    X = MsgBox("Applications Have ready been scheduled", vbOKOnly)
    Exit Sub
  Else
    'Record not found
  End If
End With




Rev032400Asked:
Who is Participating?
 
RuchiConnect With a Mentor Commented:
Try this one...

Find "SITE_NAME = '" & Text17.Text & "' "
0
 
AzraSoundCommented:
Find "SITE_NAME = Text17.Text"
0
 
Sage020999Commented:
With Adodc3.Recordset
  .Find "SITE_NAME = '" & TEXT17.text & "'"
   If Not .EOF Then
    'Record was found
    X = MsgBox("Applications Have ready been scheduled", vbOKOnly)
    Exit Sub
  Else
    'Record not found
  End If
End With
0
 
AzraSoundCommented:
sorry about that post.  my friend in the computer lab thought he'd play around on my comp til i got back.  hes not a vb programmer (obviously)
0
 
Rev032400Author Commented:
THANKS RUCHI'S AND THE OTHERS Looks like it was a race for the points.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.