Filtering form from unbound text box

  • Thread starter Thread starter Sitting Duck
  • Start date Start date
S

Sitting Duck

I have a parameter query that I want to use as the basis
for a search form. I know how to filter the data set based
on a combo or list box (Forms![FormName]![CboFieldName] in
the parameter of the query), but am stuck on how to do
this using a text box that could form any part of the
string that I want to search. IE I am not sure how the
wild card would fit into the frame of things. Have tried a
number of variations, but can't seem to fathom it out. I
will be searching on a text field and want to be able to
search for any part of the text held in the field.

Any help gratefully accepted.
 
Duck,

In the query criteria...
Like "*" & [Forms]![FormName]![ControlName] & "*"

- Steve Schapel, Microsoft Access MVP
 
Back
Top