I tried doing a search on this, but apparently "contains" is too common of a word that the search automatically deletes it as a keyword....
I have an unbound textbox where I want the user to place keywords. Then when they click the report button, I want the report generated to show all records where the keyword appears in any of the columns.
What I have right now is something to the effect of (not working anyway):
I have an unbound textbox where I want the user to place keywords. Then when they click the report button, I want the report generated to show all records where the keyword appears in any of the columns.
What I have right now is something to the effect of (not working anyway):
Code:
If Me.txtA Not Is Null Then [COLOR=Blue]'preview rptA only showing records where one of the fields contains the keywords in txtA[/COLOR]
Else [COLOR=Blue]'?Exit If?[/COLOR]
End If