Report Renaming in Access

[sundarsree]

Hi all....
I am printing a report from access in to a PDF document using a freeware called Cute PDF Writer. My requirement is to set the PDF name as a custom one taken from the report and should be saved. In present scenario it is taking the report name as the DEFAULT name. for example
my report name is SALES and when i print the report its coming default as SALES.pdf. But i need Alan Bakes.pdf where Alan Bakes is the organisation name which is there inside the report as a textbox.
Kindly help me to solve this issue.

Thanks and Regards..
Sreekanth

[orange]

See this link for similar situation
http://social.msdn.microsoft.com/For...9-276c57652edd