Saving a single record in a form as a PDF in Access 2013

[Teammom2]

I need to save a single record (preferably the current record) as a PDF. I have created a form for my boss to calculate bids. He wants to save each record individually as a PDF to upload into our service software program to attach to client files. I can save a selected record as a PDF if I print the selected record first. We need to eliminate having to print it first as it is just a waste of paper and an unnecessary step. I am kind of thinking that VBA and attaching that to a control button on the form is the way to go, but I am new to writing code and I am completely confused!! Any help?????:banghead:

 

[Mihail]

Create a report that shows ALL records (having as Record Source the table)
Hope your table has a PK (Primary Key) that identify each record.
Save the record as .pdf using this PK to filter the report.
Is easier to do than to explain

 

[Catalina]

If you use Access 2007 or later you can save a report in PDF format.
So you can design a report and save to PDF with the info of the current record.

Remember,a report is designed for printing, a form is not.

If you do some searching on this forum you will find a lot of info regarding this subject.

 

[Teammom2]

I kind of need a one step command button on the form that my computer challenged boss can click and done. I am not sure what you mean "create a report" My table does have a primary key that identifies each record.

 

[Teammom2]

There are A LOT of fields in this form. So many, in fact, the the report wizard cannot create the report. Isn't there a macro or code I can write and attach to a control in the form? I can do it if I print the selected record first.

 

[Catalina]

Like I said, do a search on 'Print Current Record' or similar and you will find a lot of information.

 

[Mihail]

So, create a report.
1) Select the table in the Navigation Panel.
2) Click the Create tab in your Ribbon and
4) Choose Report.
Return here after you accomplish this steps and you have a saved report.

 

[Teammom2]

Well, I did exactly as you instructed Catalina and only about 25% of my fields appeared in my report maybe less. As I stated there are just too many fields that need to be included and I really need my report to look exactly like my form. I know how to print a selected record AND I know how to get Access 2013 to export a PDF as a selected record IF and ONLY IF I print the selected record first. There must be a way to omit he printing step. I understand that Forms are not meant to be printed but that doesn't mean they can't be printed. I used to do it all the time at my other job.