How to creat a Search Text Feild in upon a ListBox

  • Thread starter malik via AccessMonster.com
  • Start date
M

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
 
D

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
 
Top