Filter records that include certain text strings

[Guest]

I want to create customized reports where a user can enter text strings, then
the program will search for all records that contain that text string and
display them. The filter functions are exclusive.

 

[pietlinden]

I want to create customized reports where a user can enter text strings, then
the program will search for all records that contain that text string and
display them. The filter functions are exclusive.

In the same field?

Just pass a filter in the open event of the report, and create a valid
WHERE statement without the "Where" on the front...

 

[Guest]

How do I mix a parameter and a filter?

 

[John W. Vinson]

I want to create customized reports where a user can enter text strings, then
the program will search for all records that contain that text string and
display them. The filter functions are exclusive.

Base the Report on a query referencing a textbox on the form:

LIKE "*" & [Forms]![NameOfForm]![NameOfTextbox] & "*"

and launch the report from a command button on the form.

John W. Vinson [MVP]