Where clause for subreports

[Moxy1]

I have a 3 unbound subreports that I would like opened through VB. Is there a way to open the report with a Where clause that is specific to the 3 subreports?

DoCmd.OpenReport "report",acViewPreview,,"subreport1.field = 'whatever' and subreport2.field = 'whatever' and subreport3.field = 'whatever'

 

[dhookom]

No, this won't work. You could modify the SQL property of saved queries used as record sources for your subreports.

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]