Access2007 - Name pdf dynamic

[MrRundog]

Hi, Im using access 2007 and i'm on a steep learning curve - so forgive me if my question seems odd.

I solved(with help form you guys) how to force 2007 to send a report to file (PDF) and only the report that is current.

Now, is it possible through the embedded macro to name the report as it's unique ID so that when you hit the button

- print to file -

in the save window dialogue box (FileName) should read as the ID.

I have the caption for reports to do this but the above just returns the report filename.

Cheers

 

[Fifty2One]

To dynamically assign a name to a PDF you can change the Caption of the report. Here is a sample to grab criteria from the MainMenu form where a combo box selection would set criteria to the form AND be in the saved PDF file name.

Private Sub Report_Page()
Me.Caption = "Contact price list " & Forms![frmMainMenu]![Combo2] & " 2008"
End Sub