Docmd.OutputTo a Report That has Where Condition

[Johnblaze1]

Using Docmd I know that a report can be be opened with OpenReport, and a Where condition can be set

However, Docmd.OutputTo does not appear to let me specify a Where condition.

I am using VBA. Is there a work around to this?

thank you

John

 

[GingerR]

How about putting the criteria directly in the Record Source of the report?

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[dhookom]

Other methods are:
- change the sql of the report's record source
- use a "criteria" table with a single record containing your criteria values in fields.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[FancyPrairie]

You could also create a public variable to store the Where clause.