table filter

Discussion in 'Questions (Windows Mobile)' started by billybean, Mar 2, 2009.

  1. billybean

    billybean Member Licensed User

    how do i use a textbox.text for the data in filter
    i have tried table1.filter("Front='Textbox1.text'") but it wont give any results
  2. Cableguy

    Cableguy Expert Licensed User

    This should be in Q&A....
    try table1.filter("Front=" & textbox1.text)
  3. Kintara

    Kintara Member Licensed User

    Filter with wildcard & textbox.text

    Thanks for that answer. Now, how do I do a wildcard LIKE statement using a textbox.text as the search string? I have tried many combinations of single and double quote marks and the use of "&" in several places, but I cannot seem to hit on the right one!
    Can you point me in the right direction?

  4. specci48

    specci48 Well-Known Member Licensed User

    Hi Kintara,
    here you are
    Table1.Filter("Column1 LIKE '" & TextBox1.Text & "'")
    With this you can use the wildcard * as an input character in TextBox1.

  5. Kintara

    Kintara Member Licensed User

    Many thanks

    Thaks Speccy48
    I get a bit stuck with the syntax on these things. Your answer was the perfect soloution!
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice