Help with Hyperlinking Please

First of all I would like to say a big hello to all on the forum. Great info and great reading for newbies Like myself
I am very new to access and I'm using the 2002 version.

Problem:
I have a form with a textbox, I want to add a button on the form to open the hyperlink browser. After I select the location of the file I want that URL to be entered into the textbox as a hyperlink. This has been bugging me now for 3 days. As I say I am a real, real newbie so any help would be much appreciated.

Thanks in advance.

You should set the hyperlinks data type for that field in your table as TEXT. Then use the Application.FollowHyperlink method [in the onclick event of your command button] to open the web page with your default browser. Seach the forum for the keyword "FollowHyperlink" and also my user name to see the threads I have responded to on the subject.

Also, if you want the user to be able to browse and open a selected file and/or save the "browsed" file information to a table record and/or you want the user to be able to open a file based on the stored file location information from a table record then check out my Browse [Find a directory or file] sample. Pay attention to the ShellExecute method I am using to open a file.