After clicking on a record and viewing the form, I want to save the form as a pdf with the name of the order number for that record and can this be done for a report but only for the one record I am viewing?
Thanks for your help.
After clicking on a record and viewing the form, I want to save the form as a pdf with the name of the order number for that record and can this be done for a report but only for the one record I am viewing?
Thanks for your help.
Can try OutputTo method. The form would have to be filtered to the single record. Better to export report. Open report filtered to single record in PrintPreview. Use code to execute the OutputTo or right click on the report and Export.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thank you for your prompt reply. Your last suggestion was very helpful and worked well. I have a more specific case but I will check on the forum again and with your suggestion will give it a try. I am new to Access. I have done much programming with FoxPro and I'm amazed at what you can do with Access ( if you know how to).