Hi,
I have 2 text boxes and a combo boxe that are used to create a hyperlink to various files on a server. All the file names are ina similar format DDMMYY_XXX_X, Each combo box deals with a section ie. textbox 1 deals with the date, text box 2 the initials and the combo box deals with the alpha identifer (A-Z). I use VB code to bring all this information together along with the other static parts of the address (the whole lot is called customhyperlink).
I have a simple line that says txtlink(which is bound to the link field in my table, which is set as a hyperlink) = customhyperlink, this works fine when creating a new record but fails when updating a record. The text of the hyperlink changes but not the location it points to, any ideas how to get around this?
I have 2 text boxes and a combo boxe that are used to create a hyperlink to various files on a server. All the file names are ina similar format DDMMYY_XXX_X, Each combo box deals with a section ie. textbox 1 deals with the date, text box 2 the initials and the combo box deals with the alpha identifer (A-Z). I use VB code to bring all this information together along with the other static parts of the address (the whole lot is called customhyperlink).
I have a simple line that says txtlink(which is bound to the link field in my table, which is set as a hyperlink) = customhyperlink, this works fine when creating a new record but fails when updating a record. The text of the hyperlink changes but not the location it points to, any ideas how to get around this?