Update query for hyperlinks in Access

S

Steve74

I'm attempting to update a hyperlink field via an update query. I run the
query, and the text updates, but it does not hyperlike to the address. Here
is the code I am using:
UPDATE Trainees_copy SET Trainees_copy.DocsLink = [Last Name] & [TraineeID];

The name of the table is Trainees_copy, and the hyperlink field is Docslink.
 
Top