Dany:
You might look at our PDF and Mail Library for Access. It will allow you to
automate output of Access reports from your form, specifying the output file
name in code etc. It supports multiple PDF printer drivers such as Adobe,
Win2PDF, pdfFactory etc. (each of which you must buy separately,) but once
you have one of those, the code to output your report is as simple as:
Dim objPDF as New PDFClass
With objPDF
.ReportName = "MyReport"
.PDFEngine = 3 'Win2PDF
.OutputFile = "c:\some dir\some file.pdf"
.PrintImage
End With
The Pro Plus edition of the library supports merging, securing, bookmarking,
page numbering and other attributes of PDF files as well. You'll find it on
our web.