Hi, I have a form in which I've put a search button to bring up a specific record. I want the user to only have to enter one word from a string of words (not necessarily the first word in the string).
This is what I have in the macro:
Object Type: Form
Object Name: InputCaseData
Record: First
Where Condition = :
"CaseTitle = ' "*" & [Forms]![InputCaseData]![SearchForBox] & "*" "
InputCaseData is the form name. SearchForBox is the text box to enter part the search term. CaseTitle is the field I'm searching for.
It's not working at all.
Can anyone help with this problem?
Thank you.
This is what I have in the macro:
Object Type: Form
Object Name: InputCaseData
Record: First
Where Condition = :
"CaseTitle = ' "*" & [Forms]![InputCaseData]![SearchForBox] & "*" "
InputCaseData is the form name. SearchForBox is the text box to enter part the search term. CaseTitle is the field I'm searching for.
It's not working at all.
Can anyone help with this problem?
Thank you.