• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 160
  • Last Modified:

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




0
Rev032400
Asked:
Rev032400
1 Solution
 
AzraSoundCommented:
Find "SITE_NAME = Text17.Text"
0
 
RuchiCommented:
Try this one...

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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now