Browse Files hyperlink problem

[CanWest]

I am pulling my hair out.

I am trying to get a Browse Button to populate a hyperlink field with a path and file name that can later simply be clicked on to open the file that was selected.

I have downloaded and looked at the sample database in this post Sample Database
and it works sorta. I can not seem to take what I need from this and incorporate it into my form. The only way I could work it is to use the form, module and code from the sample database, let it populate it's own unbound text box with the file and path. The on closing the form i wrote a small piece of code that populates my field with the value from the closing form. However it only populates the 'Text To Display" portion of the hyperlink field and not the actual "Address" portion.

I apologize for my lack of knowledge here but this method seems to be way over my head. Any assistance would be greatly appreciated.

Many Thanks

 

[apr pillai]

Hyperlink Address is divided into four different segments, separated by the # symbol.

Display Text#External Address#Internal Object Link#Tool Tip Text

Example-1: Hyperlink to the Word File Resume.doc

MyResume#..\My Documents\Resume.Doc

Example-2: Hyperlink to the Form Employees within the Database

Employees##Form Employees#Click

The last segment with the text Click works as a Tooltip Text.

Check the following links to design a suitable solution to your problem:

Open Forms with Hyperlinks in ListBox
File Browser in Access - read the comment section also.