Help with Code

[mattc66]

I need to add to the end of the below link after the = [stPro]

In the below example the [stPro] shows up as =# and the ProNumber

I need it to be = [pronumber] with the "[ ]" brackets. Any ideas?

Current Code>>>>>
Dim stPro As String
Dim stHyp As String

stPro = Me.ProNumber
stHyp = "
http://www.myyellow.com/dynamic/services/servlet?CONTROLLER=com.yell.ec.inter.yf

sgentracking.http.controller.TrackPro&PRONumber
="

Application.FollowHyperlink stHyp, [stPro]

 

[Regan via AccessMonster.com]

http://www.myyellow.com/dynamic/services/servlet?CONTROLLER=com.yell.ec.inter.yf

sgentracking.http.controller.TrackPro&PRONumber=" & stPro

--
Regan,
Paeroa
World famous in New Zealand

Message posted via AccessMonster.com

 

[mattc66 via AccessMonster.com]

That almost works. It put the pronumber after the = However the pronumber
must have an open [ before and a close ] after. So if pro# 019154811 is the
pronumber it would look like this at the end of the hyper link:
=[019154811]

 

[mattc66 via AccessMonster.com]

Okay - I figured it out myself. Maybe this stuff is starting to click.

= " & "[" & stPro & "]"

Thanks All

That almost works. It put the pronumber after the = However the pronumber
must have an open [ before and a close ] after. So if pro# 019154811 is the
pronumber it would look like this at the end of the hyper link:
=[019154811]

http://www.myyellow.com/dynamic/services/servlet?CONTROLLER=com.yell.ec.inter.yf

sgentracking.http.controller.TrackPro&PRONumber=" & stPro