Recent content by saints9626

That's now working brilliantly thank-you! Don't suppose there's a way to look for a file across multiple folders? I wish to have another link similar but the files are sorted in folders ie. "0-99" - "100-199" - "200-299" etc. Any help much appreciated

Thankyou for the help, After doing what you said a new error appears; "Compile Error: Syntax Error" I have also attached a shot of the debugger in VBA after this error code is displayed. Many Thanks

Hi, I typed the following code into the "on click" property of the text box used for the order number in the form. =[FollowHyperlink]="Y:\Orders\" & [me].[Text45] & ".pdf" Y:\Orders| being where the PDF is saved. PDF Named "19109". Text45 being the name of the text box on the subform where...

The file name is the exact same as the text in the field. Is there a way to automate that slightly? i.e. the user just enters the order number and it then becomes a link? Thanks for the reply

Hello, Sorry if this has already been asked but after many searches I cannot find an answer. I have a Form, containing a Subform, in the subform is a field called "Order No". This number will be entered on the subform, but i wish for this to become a link to the corresponding PDF file upon...