G
Greg Snidow
Hello everyone. I am having trouble getting my search button to work. I
have tried using many different approaches I found in previous posts, but the
closest I could come to success is for the next record to be selected, not
the one I entered in the search text box. The following is the code with my
field names.
Private Sub txtSearch_AfterUpdate()
If IsNull(txtSearch) Then
Me.FilterOn = False
Else
Me.Filter = "[EWO] like """ & txtSearch & "*"""
Me.FilterOn = True
End If
End Sub
When I hit enter the first record in the table is selected, not the one
corresponding to what I entered in txtSearch. I also tried using this code
on the on click event of my search button, cmdSearch, because I want to hit
the button to bring up the record rather than hit enter. I am using an ADP
with SQL 2K as the backend. Is there something different I need to do since
I am using ADP? I do not know much about code. Thanks in advance.
have tried using many different approaches I found in previous posts, but the
closest I could come to success is for the next record to be selected, not
the one I entered in the search text box. The following is the code with my
field names.
Private Sub txtSearch_AfterUpdate()
If IsNull(txtSearch) Then
Me.FilterOn = False
Else
Me.Filter = "[EWO] like """ & txtSearch & "*"""
Me.FilterOn = True
End If
End Sub
When I hit enter the first record in the table is selected, not the one
corresponding to what I entered in txtSearch. I also tried using this code
on the on click event of my search button, cmdSearch, because I want to hit
the button to bring up the record rather than hit enter. I am using an ADP
with SQL 2K as the backend. Is there something different I need to do since
I am using ADP? I do not know much about code. Thanks in advance.