How to creat a Search Text Feild in upon a ListBox

[malik via AccessMonster.com]

Hi

I want to creat a Text Feild on a List Box from I can search by typing in
the text Feild.

Thanks

 

[Danny Lesandrini]

Are you saying that you want to FILTER a LISTBOX by the text supplied in a
TEXTBOX?

Dim strSQL as String

strSQL = "SELECT * FROM qryListBoxQuery WHERE [FieldToFilter] LIKE '" &
Nz(Me!txtFilter, "*") & "'"
Me!lstListBox.RowSource = strSQL