Button to initiate hyperlink in field

[fitshase]

I have created a database but I have absolutely no experience of VBA so I'm hoping someone can help.

The database I have created is designed to keep a record of sites we have (address, owner, location, site type, etc). I have 2 separate fields for the Easting and Northing values.

I have created a query which has a field to insert the Easting and Northing values into a hyperlink:-

Hyperlink: "http://www.magic.gov.uk/website/magic/viewer.htm?startTopic=maggb&xygridref=" & [Easting] & "," & [Northing] & "&startScale=3500"

Now, when I create a form based on the query, I have to set the box to Hyperlink=Yes in the properties. However, when I view the form and click the hyperlink, the web bar appears in Access but Internet Explorer does not open to the hyperlink.

What I want to do is to keep the hyperlink field hidden and create a button which I can place on the original form which will then take the user to the map for that site.

Can someone help me please?

Cheers

Ross

 

[stopher]

There are several useful posts here

hth
Chris

 

[fitshase]

Thank you so much. I tried searching the forum but somehow found extremely complicated answers for similar requests (although not identical to what I wanted to do).

The link you gave me worked a treat.

Thanks again.

Regards

Ross