'Microsoft Access- launch hyperlink contained in data table via button located on form

Using SQL or VBA, what is the code I would need to launch a hyperlink which would go to either the internet or a network location? The form has multiple buttons which would connect 1:1 with the first column in the table. The second column in the table would either have an "http://www.internet.com/databases" or "\network7\HH\forms\hrl\".

Only the admin would have access to the table, and the end-users only have access to the forms. This allows all the users to click on the button and have the website or network location launch automatically, without having the ability to edit the table, which the admin would have.

Within "OnClick", I cannot simply type "FollowHyperlink(http://www._____) because the location (written in the table) would be changing monthly and the admin would have 0 coding or technical background.

The button would not be opening a table or showing the user what is happening, it would only launch the link and remain on the same screen to allow them to click on another button

Thank you in advance,

JT so far i have:

Dim hyperlink As String

hyperlink = Nz((DLookup("Field2", "sources", "[Field1] = SAP"),"")

If Len(hyperlink) > 0 then 
    FollowHyperlink (hyperlink)
End If


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source