I have a list box on a form that uses a query to populate it. The query selects the returns based upon a text box on a page of the form. I would like to have the query place the wild card search * just prior to and just after the data that it looks for from that text box. So that the critera would look like
Like Forms![Fm Staff Input]!*[Unique ID Number]*
This would have the same result of creating a parameter query and having the operator input *00045*.
Is this possible as the criteria above doesn't work.