This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 15%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELA%3C/text%3E%3C/svg%3E)
I am trying to provide a sharepoint hyperlink to the users. The way I am going about this is setting the end of the link to the ID of the item but the hyperlink is the same for each item. How can I fix this. Below is a picture of my code in the load event. This is a continuous form btw.
If you're trying to do this from within the table, I am not sure it will work. However, if you're doing this using a query, then I think it could work. Otherwise, I can think of two other options.
How could I do this using a query?
Hmm, actually, you're right. You can add the ID to the link, but it won't become a hyperlink in the query result. You would still end up using some code (like on a form) to make it a clickable link.
Yeah I managed to add the ID to the link and open the link using the Application.FollowHyperlink command in vba but the issue I have is that they are all the same links. How do I make each link have its own ID number?
By the way i have a query in the record source of the form. The hyperlink textbox is not a part of the query though.
I made an expression through concatenation and using the left and right function. Fortunately it seems to work.
Glad to hear you got it sorted out. Good luck with the rest of your project.