I am trying to dynamically create a hyperlink on a form based on parameters in the record returned to my form. basically pass named valued pairs in the querystring. I have a little VBA experience.
 

---

Answer from Richard Rost:

A Hyperlink field is really just a special kind of text field in this format:

visible_text#URL

So to jump to my page, you would say:

Click here#http://www.599cd.com

You can create this dynamically in your form's code using something like a button or an AfterUpdate event for another field:

myHyperlink = "Click here#" & URLfield

You can even follow that link in VBA code using the.follow method.

I cover this in great detail in my Access 327 course. In fact, lessons 5 and 6 are all about how hyperlinks work, how to build them in VBA code, and even launch them in your browser.

http://www.599cd.com/site/courselist/access/access327/?key=BlFAlEx