Using a form, how to PDF a single record using command button

[jonrod]

Novice here! I have limited experience in using MS Access.



Background: I have inserted a PDF command button into the form. I am trying to create a PDF for a single form/record; however; MS Acess PDF's all of the forms/records.

I need to do the following:

1. Create a command button that produces a single PDF for a single form/record.

Any assistance would be greatly appreciated.

[pbaldy]

I would output a report rather than a form; you have a lot more control over the look and feel. Easiest for you is probably to use this to open a report filtered in preview mode:

BaldyWeb wherecondition

then use OutputTo to create the PDF, then close the report.

[jonrod]

Thank for your response Paul.

I'm sorry, I need to clarify. Is this being done in VBA? I am not familiar with that tool. Or is this a an embedded macro?

Again, thank you.

Also, I'm stuck using the form method (for now). I am on a deadline and redesigning the look of the form in report view would be more time consuming, I believe.

[June7]

Either way, have to filter the dataset. Apply filter to the form so only the one record is included.

I agree with Paul, simplest is to open filtered report - report in Print Preview, not Report View. The example code is VBA although there is macro equivalent. It can be in the button Click event.

Building simple report shouldn't take long. Can even copy/paste controls from the form.

[pbaldy]

I'll get out of the way.

[jonrod]

I tried both but I am not having much luck.

I know that I'm doing something wrong. Any insight? Lost one right here.

[June7]

What happens - error message, wrong results, nothing?

Post the code you attempted or provide the db for analysis. Follow instructions at bottom of my post.