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.
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.