Macro to save form in PDF

[hbah923]

Running Access 2007. Have a form that i would like to have a button that when clicked would save the record form to a PDF and use the unique serial number that is in one of the text boxes on the form as the file name. Not very good at macros. Thanks for any replies.

 

[Taruz]

Hi..

Try this..:



DoCmd.OutputTo acOutputForm, "form_name", acFormatPDF, _
me.textbox_name & ".pdf", True, "", 0



.

 

[hbah923]

Ok so my text box that has the serial number is named "SerialNumber" and the form name is "DataBase". Not sure it these go where you have red or not. Sorry for being difficult.