table filter

[billybean]

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

 

[Cableguy]

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

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

 

[Kintara]

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?
Thanks

Kintara:sign0104:

 

[specci48]

Hi Kintara,
here you are

Table1.Filter("Column1 LIKE '" & TextBox1.Text & "'")

With this you can use the wildcard * as an input character in TextBox1.


specci48

 

[Kintara]

Many thanks

Thaks Speccy48
I get a bit stuck with the syntax on these things. Your answer was the perfect soloution!
Kintara