Member Avatar for markdean.expres

This filtering concerns of mine have been bothering me. I hope you guys will not get irritated because I have another one.

My client wants that my table be filtered based on the values from a field regardless of its order.

Example: I want to search for a student whose surname is 'Thomas' but the keyword is not the first in the field. The 'Surname' field, instead, contains the value "Ian Thomas".

If I am going to use this code;

bindingsource.filter = "surname Like '" & textbox1.text & "'"

It will base the searching on the first characters of the field only. I hope you got what I mean here.

  • 2 Contributors
  • 1 Reply
  • 74 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by sandeepparekh9
Member Avatar for sandeepparekh9

Hi.. Do somthing like this

Dim filter() As String
        filter = Me.TextBox1.Text.Split(" ")

        BindingSource.Filter = "surname like '" & filter(0) & "' or surname like '" & filter(1) & "'"
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.