Automatically print to pdf and change the filename to a field value.

[russ0670]

I want to be able to in a form click a button which automatically creates a report converts it to .pdf and set the PDF file name to one of the field values and saves it in a specific location (k:/statements)



E.G if field "accountno" in tblaccount is 45678 then the pdf would be called k:/statements/45678.pdf

Table Name= tblaccount

Form Name= frmaccount

Report Name= rptstatement

does anyone know the code to do this or a good forum posting to help (had a look on here and Google and could not find anything definitive)

[RuralGuy]

I use Stephan Lebans code for this operation. http://www.lebans.com/reporttopdf.htm