Search results

moke123 , I am very much obliged to you . Your formula was very high But you just defined for one Text box and search in all Fields I wanted to...

Thank you very much for this remark It's awfully kind of you Please using defined module

any idea ??

finely I attached the sample Filter listbox

honestly I say? I want best and fast way to filter in too much data About 32 Field and 98000 ID I'm very grateful if anyone can give me a sample

yes In the change event

sorry unfortunately not resolved

where is my fault in this code ? for text1 : Private Sub Text1_Change() Me.List2.RowSource = "SELECT * FROM Table1 WHERE " & _ (Search("[Fname]", "Table1", Nz(Me.Text1.Text))) And (Search("[Contry]", "Table1", Nz(Me.Text2.Text))) Me.List2.Requery End Sub and for text2 Private Sub...

Special Thanks to dear friends for replay this code for just one textbox Private Sub Text10_Change() Me.List2.RowSource = "SELECT * FROM Table1 WHERE " & Search("[Fname] & [Contry] & [Age] & [Phon]", "Table1", Nz(Me.Text10.Text)) Me.List2.Requery End Sub...

========================== Compile Error: Variable not defined what is this error for?? and how can fix it ??

Thanks for your help Excellent My Friend

hi everyone I have a module for filtering subform bese on 4 Fields in onchange event and I cant use it to filtering Listbox . can anyone help please ? Module Code : Option Compare Database Function Search(Expr As String, Domain As String, txt_search As String) As String x = txt_search & " "...

thank you sir

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