Updating Hyperlink Address on Load Microsoft Access -

i have form in access 2007 database , need automatically update hyperlink address when form loads add id number @ end (when form loads, loads id table. id needs added @ end of hyperlink). basically, whenever form loads, need dynamically create hyperlink address based off of id field.

for instance:

before load: url=
after load: url=1

where 1 selected id table

access supports several "events" triggered when form opened. 1 of load event fires when form first loaded. details, here.

you add code form_load event handler update string in question, like...

myhyperlink = myhyperlink & [id] 

...which happen once, when form first loads. if want hyperlink updated move between records (while form open) use current event instead, , use like

mybasehyperlink = "http://example.com/id=" myhyperlink = mybasehyperlink & [id]