Hi
I have spent a considerable amount of time researching this excellent resource and learnt a great deal since joining the forum, but I cant find the answer to this.

I have a User form created with a number of fields. One of the fields needs to be a hyperlink that is created once the file reference (a number) is entered. Can anyone help me with the syntax thanks.

The fixed reference to create the link is static and will not change

"http://server/WSINT/Default.asp?redirect=http://server/WSINT/scripts/GetDoc.asp?nrtid=!nrtdms:0:!session:127.0.0.1:!database:REFERENCE:!document:nnnnnn,n:"

When the user enters the number "nnnnnn" in the textfield (the comma preceeds the version number) on save or edit I need to attach the hyperlink described above to show the hyperlink displaying only the nnnnnn,n in the Form or spreadsheet - thus allowing the user to click the created hyperlink to open the file on demand.


Thanks in advance.