So, I'd like to have my search text box on a form. When it is populated, it is pulled up in a query that contains criteria in the form of like "*________*" so that all of the information in the text box is searched for. The problem is that I can't seem to get the criteria to read or pull from the search box (RelationshipSearchEntry)
I'm using this
like "*[Forms]![FamilyTreeForm]![RelationshipSearchEntry]*"
in the criteria.
What am I doing wrong, or not doing right?
Thanks!
I'm using this
like "*[Forms]![FamilyTreeForm]![RelationshipSearchEntry]*"
in the criteria.
What am I doing wrong, or not doing right?
Thanks!