I have a list box that is propagated by a query
that query has the criteria that the description field of the table should contain the value of the txtLookup field on the form. but if the description is "I like the car" I can only bring it up if I type verbatim "I like the car" I want it to work if I type "car" too.
but I can't say like "*[Forms]![frmKnowledgebase]![txtLookup]*" like I can say like "*car*"
so how do I get it to respond to the criteria where the string in the text box is contained in the field, not the exact contents of the field.
that query has the criteria that the description field of the table should contain the value of the txtLookup field on the form. but if the description is "I like the car" I can only bring it up if I type verbatim "I like the car" I want it to work if I type "car" too.
but I can't say like "*[Forms]![frmKnowledgebase]![txtLookup]*" like I can say like "*car*"
so how do I get it to respond to the criteria where the string in the text box is contained in the field, not the exact contents of the field.
