Report using current DAO record data

[normever]

I have a DAO recordset that loops through the records one at a time. It prints PDF files for each record where the path is contained in a field. I want to prepare a cover sheet for each PDF with information contained in the current record only each time it loops and prints the PDF. How do i define the recordsource for the Report using the current record of the DAO recordset only?



The DAO is defined by a query. If I assign the query as the recordsource for the Report I get all the records in the recordset on the report. The report does not recognize by temporary DAO recordset as a valid recordsource.

thank you,

--Norm Everhart

[June7]

Cannot use Recordset as the data source for a report. The report RecordSource must be a table, query, or SQL statement.

For code that outputs report to PDF, review https://www.accessforums.net/import-...ges-25042.html

For code that combines multiple PDFs into a single PDF, review https://www.accessforums.net/access/...pdf-25574.html