Help For Multi Filter ListBox in form (1 Viewer)

[zozzz]

hi everyone

I Have Three Fields and One Textbox in the Form
Q: How Can I When Type in Textbox , The Listbox be Filter
N: (please complete the sample )

thanks

 

[CJ_London]

in your text4 change event put

Private Sub Text4_Change()
List2.Requery
End Sub

and in your List2 rowsource put

SELECT [Table1].[ID], [Table1].[Fname], [Table1].[Lname], [Table1].[Phone], [Table1].[Address] FROM Table1 WHERE fname Like "*" & text4.text & "*" or lname Like "*" & text4.text & "*" or phone Like "*" & text4.text & "*" ORDER BY [ID];

(just copy and paste)

 

[zozzz]

thank you sir