Save attachment from a report

[Grant Shea]

I have a field in my database that is for attachments. What i would like to happen is when i generate a report, IF there is an attachment in that report it will prompt the user "This report has an attachment" and after clicking ok, open that attachment automatically. Can someone help me with VBA code for this?

[ItsMe]

I think you are going to have to export the file from the DB using VBA and then something like a followhyperlink. Another approach might be to set focus on an Attachment control and use SendKeys.