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?
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?