save the result of a wildcard search?

O

Octavia_D

Is there a way to save the text string of a wilcard search? I would like to
display the results of the wildcard search records in a report as part of the
Header. Thank you!
 
J

John Vinson

Is there a way to save the text string of a wilcard search? I would like to
display the results of the wildcard search records in a report as part of the
Header. Thank you!
Click to expand...

If it's a Parameter query you can: e.g. if your criterion is

LIKE [Enter search criterion:]

you can put

=[Enter search criterion:] as the control source of a report header
textbox. If the user enters

*xyz*

that's what will show up in the control.

I'm not sure that's what you mean by "the results" though - wouldn't
the results of the query be the query recordsource for the Report
itself?

John W. Vinson[MVP]
 
Top