Hyperlink based on control

[Mike]

Hello all.

I need to set up a hyperlink on a form that starts with a web address
http://maps.google.com/maps?q= and then adds two fields to the end with a
space between them. I tried
http://maps.google.com/maps?q=&[ShipperAddress]&" "&[ShipperZip]
with no success. Any ideas?

Thanks as always
Mike

 

[t568aort568b]

This is what I use.
"http://maps.msn.com/home.aspx?strt1=" & strAdd & "&zipc1=" & strZip &
"&cnty1=0"

Private Sub Map_Click()

Dim strMap As String
Dim strAdd As String
Dim strZip As String
strAdd = Me.Address
strZip = Me.Zip_Code
strMap = "http://maps.msn.com/home.aspx?strt1=" & strAdd &
"&zipc1=" & strZip & "&cnty1=0"
Application.FollowHyperlink strMap


End Sub
That's my code for a map button.
the msn full web address is:
http://maps.msn.com/home.aspx?strt1=1 Microsoft
Way&city1=Redmond&stnm1=WA&zipc1=981052&cnty1=0

I just use street address and zip.
Good Luck,
Eric

 

[Mike]

Great!

Thanks