Woodman650
Technical User
Hey guys,
I've got a listbox that is filtered down depending on the values a user puts into an input box, on-the-fly. However, the requery onchange doesn't allow users to add spaces to the search field.
I'm using the code:
Now, I'm pretty certain the Recalc function is what is giving me the problem... but I'm wondering how I can't rework the code to accomodate a user entering a space value in their string. Any ideas? thanks!
I've got a listbox that is filtered down depending on the values a user puts into an input box, on-the-fly. However, the requery onchange doesn't allow users to add spaces to the search field.
I'm using the code:
Code:
Private Sub textText_Change()
Me.lstList.Requery
Me.Recalc
Me.txtText.SelStart = Len(Me.txtText.Text)
End Sub