"Quick Search" function... need a little VBA help...

[Woodman650]

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:

Private Sub textText_Change()
Me.lstList.Requery
Me.Recalc
Me.txtText.SelStart = Len(Me.txtText.Text)
End Sub

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!

 

[lespaul]

what do you mean by 'add spaces to the search field'?


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[Woodman650]

meaning... when you hit the spacebar on your keyboard, the blinking cursor moves forward a space. instead, it gets moved back and a user cannot insert spaces into their query. Instead of typing "a word here", they can only type "awordhere" and the results don't come up accurately. thanks