G
Guest
Hello.
I have implemented an incremental search solution from the Access 2000
Developer's Handbook into one of my forms. The solution uses a text box on
top of a list box in order to simulate a permenantly open combo box which
searches as you type.
I have a button that clears the search values between searches similar to
the following:
Private Sub cmdClearSearch_Click()
Me.FilterOn = False
Me.txtIncSrch.Value = Null
Me.lstIncSrch.Value = Null
End Sub
The above procedure will clear the text from the text box and the
highlighted line from the list box, however, the list box will remain
scrolled down to where the last selected line was located. Is there a
statement I could add that would make the list box scroll back to the top
when I run the ClearSearch command?
Many Thanks!
I have implemented an incremental search solution from the Access 2000
Developer's Handbook into one of my forms. The solution uses a text box on
top of a list box in order to simulate a permenantly open combo box which
searches as you type.
I have a button that clears the search values between searches similar to
the following:
Private Sub cmdClearSearch_Click()
Me.FilterOn = False
Me.txtIncSrch.Value = Null
Me.lstIncSrch.Value = Null
End Sub
The above procedure will clear the text from the text box and the
highlighted line from the list box, however, the list box will remain
scrolled down to where the last selected line was located. Is there a
statement I could add that would make the list box scroll back to the top
when I run the ClearSearch command?
Many Thanks!