hyperlink URL with embedded reference to a value

[lread123]

Hi

I would like to know if it is possible in Access 2007 to add a button/hyperlink where by the order number (as in the example below) is being sourced from another field [ORDNR]

i.e. replacing the 0996653 for example with a lookup to the ordernumber held in another column?!

http://lp34web.w34:4524/baa/jsp/ord...=apipso79.w34:IPS_MON&ordnr=0996653&baaSubmit

this link is one from a web url - I want to copy this in my DB.

hope someone can help..
thanks

 

[lread123]

Hi
just noticed that the link doesn't display all correctly hopefully this will work:
so this is the one from the web page I want to replecate as a hyperlink in access:

http:// lp34web.w34:4524/baa/jsp/order_information/osm/orderinfo.jsp?packageUser=apipso79.w34:IPS_MON&ordnr=0996653&baaSubmit

so the link is fixed other than the red bit! and its the order number that needs to referenced from another field called [ORDNR]

so this is the sort of thing (i think) i need:

http:// blar blar lp34web.w34:4524/baa/jsp/order_information/osm/orderinfo.jsp?packageUser=apipso79.w34:IPS_MON&ordnr=[ORDNR]&baaSubmit

I have read this thread but sorry 'I don't get it'? :-( http://www.access-programmers.co.uk/forums/showthread.php?t=203228 )

any help please?