[dba-Tech] Combining a query with a report

Thanks! I'll give it a whirl.

Arthur

On 10/15/07, Rusty Hammond <rustykh at yahoo.com> wrote:
>
> I've not tried it, but can you take the current filter applied to the
> form, and use that as your WHERE clause when opening the report.
>
> For example if calling the report from the same form do the following:
>
> DoCmd.OpenReport "YourReportNameHere", acViewPreview, , Me.Filter
>
> HTH,
>
> Rusty
>