i have a list box with 100's of rows. I'd like to create an unbound field that as a user types it will begin to filter down the list. Has anybody attempted this and would you be able to point me to some examples?
Here is basically what i've tried:
The problem that i run in to is that when the search field is changed the new value is not being picked up.
Here is basically what i've tried:
Code:
Private Sub txtSearch_Change()
Dim strSearch As String
Dim strValue As String
strValue = Me.txtSearch
strSearch = "SELECT DISTINCT tblObject.obj_location FROM tblObject WHERE (((tblObject.ojb_type)=Forms!frmMainObject!txtType)) AND ((tblObject.ojb_location) Like '" & strValue & "*'; "
Me.lstBox.RowSource = strSearch
End Sub
The problem that i run in to is that when the search field is changed the new value is not being picked up.