export multiple page form with specific field as respective filename

[databasewolfy]

Is there an easy way to export a form with roughly 50,000 entries into PDF files with a specific field as the file name?

[CJ_London]

think you need to clarify - you want to generate 50000 pdf's?

the export part is easy, use the docmd.outputto method - https://docs.microsoft.com/en-us/off...docmd.outputto

As to the rest of it, all depends on what you are actually trying to do

[ranman256]

thats called a Report.
the query pulls the data into the report,
use a form and listbox to filter by 'dept' (or other list) then the output would be like:

vFile = "c:\folder\MyReport_" & cboDept & "_" & format(Date,"yymmdd-hhnn") & ".pdf"
DoCmd.OutputTo acOutputReport, "rMyReport", acFormatPDF, vFile