Hyperlink using field data

[Cory]

I tried to figure out how to do this but in the end failed and come to you
all for help. I know it's probably really simple and odds are it's my
preconception of how it should be done that's frustrating me so I figure
I'll just tell you my situation and goal inn hopes someone can tell me how.

I have a flat table of data which is not very large and I usually interface
to it with a simple form. Now in that form I have a field for a UPS tracking
number. As it is now I made the field a "Hyperlink" type which has the
drawback of requiring me to right click it and do a lot of manipulation each
time to add the chunk of text
"http://wwwapps.ups.com/ietracking/tracking.cgi?tracknum=" to the front of
the number to make it work. Also I need to revise the "Display" to only show
the number. This is a pain and I would like to change it.

I realized that I didn't really want a hypertext field but rather just a
text field that I could paste the tracking number into. What I really want
is a button next to the tracking number field that would jump me to the UPS
tracking page using the value in that field. Can someone tell me how to do
this?

One thought I had was to have a hidden field that would be a composite of
the UPS link prefix and the tracking number but I don't know how to make a
button or better yet a picture link to a field that way.

Thanks in advance for your help!

 

[Van T. Dinh]

In the CommandButton_Click Event, try the statement
something like:

Application.FollowHyperlink _
"http://wwwapps.ups.com/ietracking/tracking.cgi?tracknum="
& Me.TrackNumField

HTH
Van T. Dinh
MVP (Access)