How to change drive letter in input form

[pbaldy]

It would have helped to see the full SQL, but you want that in the Update To area, not the Criteria area. Also, again, you want the name of the field in the first argument, not a literal string. Have you looked in Help at the Replace function?

[amer]

Thanks to Suzan I was able to get this done. It was actually easy once I new what to do. As the JOE's say " knowing is half the battle"

I selected my table.

Selected my field.

Changed the data type from hyperlink to text. ( this showed me all the actual hyperlinks)

Then I used the replace command to change the directory in the hyperlinks from J:\ to R:\

Finally I changed the data type from text back to hyperlink and it worked perfect.

Here is a link to the actual thread that lead me to this.

https://www.accessforums.net/forms/ho...rlink-282.html

Hope this can help...