dead hyperlinks

mikeder

Member
Local time
Today, 14:32
Joined
Nov 12, 2002
Messages
34
I am having tremendous problems with what should be a simple function with hyperlinks. Here is the situation...

I have a projects table that contains project fields such as Projects.Project_ID, Projects.Project_Code, Projects_Address_ID etc...

I also have a Server_Location table that contains 2 fields, Address_ID and Address. The function of this Server_Location table is to store a list of hyperlinked file locations to where our project files are stored on the server.

What I wanted to do was put a drop down field on a Projects form that indicates the file location of a project on our server.

The Record Source for my projects form is Projects.
There is a combo box on this form who's control source is Address_ID

Row Source of the combo box is: SELECT Server_location.Address_ID, Server_location.Address FROM Server_location;

When I try to click on a hyperlink on my form, the link is dead. I believe this has something to do with the fact that the Server_Location table is being lined to the Projects table via the Address_ID field.

I'm in need of help. Can anyone tell me how to get these hyperlinks to open a browser window?
 

Users who are viewing this thread

Back
Top Bottom