Save individual form as PDF

[ashu.doc]

Hi everyone


I would like to save individual form (Single customer record) as PDF. How can I do that?

Thanks
Ash

[CJ_London]

look at using the docmd.outputto method in a button click event on your form - something like

DoCmd.OutputTo acOutputForm, "myForm", acFormatPDF, "C:\" & me.name & ".pdf"

see this link for more information

https://msdn.microsoft.com/en-us/lib.../ff192065.aspx

[ashu.doc]

Hi Ajax
That code save all the forms in the database, what I am trying is to save only one form for one customer whichever I want. So suppose I enter all the details of a person and want to print/save the details in the same format (form) as I entered.
Thanks

[CJ_London]

what do you mean by 'all the forms in the database' - all those that are open? all of them, open or not? one form but all customers? something else?

[ashu.doc]

I use a common form for each customer to enter data. When I use your code or outputto macro to save form it saves all the forms for all the customer in one PDF file.

[ItsMe]

Did you include the name of your Form?

DoCmd.OutputTo acOutputForm, "myForm" , acFormatPDF, "C:\" & me.name & ".pdf"

Perhaps you are talking about all of the records and not all of the forms.

[June7]

You will have to apply a filter to the form so that only the desired record(s) are output. Reports are better instrument for outputting data to PDF or print. Report would also need filter.

Review http://www.allenbrowne.com/ser-62.html