Filter records that include certain text strings

D

Dean Welch

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

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.
Click to expand...

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

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.
Click to expand...

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]
 
Top