Output Filtered Report (1 Viewer)

Hi, I need to be able to output a filtered report if possible. The only way I've managed to do it so far is to open the report (specifying the WHERE criteria) then output it, then close it.
This is undesirable because the DB is an automated response handler and I don't want reports to be flashing up all the time.
Setting the reports RecordSource doesn't work because the report needs to be opened first which would give the same problem as above.

The criteria for the filter comes from a recordset in VB so I can't just set up a query and set the source to the query...

Any Ideas?

Thanks, Tom.

What I usually do in this situation is create a module variable to store the value of the parameter and then a public property to retrieve the value. Then you can set the query for the report to filter based on the variable's value.