I have a report based on a query. The query has a ole bound object that is referred to as FamilyFile1. I want to put a command button on my report that will open FamilyFile1. This is normally a PDF file - but sometimes a word file. I have found code on how to open files with a command button, but none on how to open a different file for each report.
Can someone give me the on click event code that will open the file?
Thanks