Report: Have field that is hyperlinked to excel files. Need to open in 1

[spotspot]

Please help. I have the following:
Tablename = Table1
Fieldname = Blind_list ( hyperlink to appropriate file)
Query = JSA_Safework. This query pulls all the data required for OSHA safe file from several tables. It pulls in field that is a hyperlink to associated excel file.
Report = JSARPT. RPT uses JSA_SAFEwork query. I need the hyperlink to the excel file to open for printing. I can get the text box bound to the correct field...but it places the actual link to the file (field contents) in the report, but doesn't open it. I've searched the forums and haven't found this question. I'd appreciate any help with this.

 

[ZmrAbdulla]

Reports don't have clickable areas..
Use forms insted if you require that function.
Look for "Application.FollowHyperlink" in the help

________________________________________________________
Zameer Abdulla
Help to find Missing people