Cmd Button on Form to print Filtered List (1 Viewer)

[trstorer]

I have a form that displays the filtered results of a search for a keyword - there is code that uses a where clause in a memo field. The keyword comes from a form that "collects and holds" the variable information.

I want to be able to have a command button on the form to click and print a report that displays a list of only those records that satisfied the initial keyword search.

Right now the report prints every record in the table - the report is based on the tblDoc - I have turned filter on.

I tried including the where clause in the -
Docmd.openreport "reportname", acpreview,,vwhere
- which still didn't work.

Thanks for any ideas.