I have a provider report that has a group footing at the provider
name. I would like to run this report and save the output of the
report as a .pdf for each provider. The report is run with a record
selection criteria and grouped by provider. There is a page break at
the change of a provider. I would like to save the report by provider,
but run the report once.

I was thinking of using this command:
DoCmd.OutputTo acOutputReport, theReportName,
acFormatPDF,outputPDFFilename, False

But don't know how I can get it to cycle through the records and save
the report at the change of a provider. Any suggestions/examples?

On Nov 1, 9:21*am, Annette <annet... (AT) co (DOT) saint-croix.wi.us> wrote:
I don't know how you expect to send the output for all records and
have the PDF chop it up per provider.

Better to group on provider in a query and then take that list and do
a report for each on.