Button to Open HTML contained in Text Field

[Douglas Post]

I have an image that I want to utilize as a button. What I want to accomplish is when I click on the button it looks to a text field in the same form called "Listing". I want is the path for the Hyperlink to be whatever is contained in this "Listing" field. I cannot hard code the hyperlink to the image as each record has a different URL.

Late on I want to create an image of Bing Maps, and when I click this image it looks to the Address, City, State, Zip text fields in the same record, modifies the URL path so the return would open the browser and zoom right to the subject address.

I think the answer to the first will solve my answer to the second issue.

Your help is appreciated in advance.

[Douglas Post]

I solved the problem by making the field "Listing" a text field not a Hyperlink field as it added # before and after the URL. I then wrote the following event proceedure:

Private Sub Button_Click()
Call FollowHyperlink(Me.
[Listing])
End Sub

Where the images name is "Button" and the text field containing the URL is "Listing"