Automate a search field into a web page hyperlink??

[davi5007]

Hi,

Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString . How can I get this into the hyperlink so it uses it to find the correct record?

This is the line of code with the hyperlink:

Application.Fol lowHyperlink "http://viewitd.com/UnitTrace/ListUnitTrace.a sp?&ListProduct =0&ListProductV ar1=0&ListProdu ctVar2=0&ListPr oductVar3=0&Des patchNo=&Tracea bilityNo =&SerialNo=&Sta rtDateTime=&End DateTime=&Title String=+++strSe archString&sPro duct= "


I've been trying the likes of e.g TraceabilityNo = strSearchString but it's not happening. Is it a syntax thing or am I way off ??!

Any help would be great thanks !

M

[cactusdata]

Probably something like this:

strSearchString = "456"

Dim HyperLink As String

HyperLink = "http://viewitd.com/UnitTrace/ListUnitTrace.asp?&ListProduct=0&ListProductVar1=0 &ListProductVar2=0&ListProductVar3=0&DespatchNo=&TraceabilityNo=" & strSearchString & "&StartDateTime=&EndDateTime=&TitleStrin g=+++strSearchString&sProduct="

Application.FollowHyperlink HyperLink