Listbox and textbox update (1 Viewer)

[jfgambit]

I have a listbox (based on a Like "*" query) on a form that needs to update when a user enters names into a textbox on the same form. Here's the catch, the listbox needs to update after each letter is entered. In otherwords, if I am looking up SMITH, after I type "S" all the names like "S" appear, when I type "M" all the names with "SM" come up...etc, etc.

I have tried the OnChange Event by adding me.refresh, but the next letter is overwritten in the textbox and instead of looking up "SM" it only has "M". I have aslo tried me.lstboxname.requery, but the listbox does not update.

Any ideas??

 

[Rich]

Have you tried ListboxName.Requery ?

 

[jfgambit]

yes, but nothing happens

 

[jfgambit]

Changed the Event code to:

Private Sub txtSearch_Change()
Me.Refresh
Me.txtSearch.SelStart = Me.txtSearch.SelLength
End Sub

and it works fine...

Thanks

 

[Pat Hartman]

Why not switch to a combo. The behaviour that you are seeking is the default behaviour for combos.