Trying to write an IF-Then statement to search a specific field for records in a table. I want the end user to be able to enter a value in a textbox (called "WCText"). And, I want the code to return to them all records that has that string somewhere in the field (field called "TIK_TITLE" in dataset tmp_RST).
So, in laymen's terms, end user enters the word "summary" (without the quotes) in the text box and I want to return all records that have this word somewhere in the field "TIK_TITLE". This is what I have come up with so far:
If (UCase(tmp_RST![TIK_TITLE].value) Like ("*" & UCase(Me.WCText) & "*")) Then
I always get messed up with syntax for quotations. This is not giving me any hard errors when I run it. But, it is giving me records that do not have my search parameter in them?
Can someone tell me if my syntax is wrong? And, what should it be? Thanks!