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.FollowHyperlink "http://viewitd.com/UnitTrace/ListUnitTrace.asp?&ListProduct=0&ListProductVar1=0 &ListProductVar2=0&ListProductVar3=0&DespatchNo=&T raceabilityNo =&SerialNo=&StartDateTime=&EndDateTime=&TitleStrin g=+++strSearchString&sProduct= "


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