I have a form with a control to lookup a folder and insert the folder name in the text box (called 'location'). I have another field that is a hyperlink field (called picky)and am using a command button to update the 'picky' field that is simply:
picky.value= location.value

The problem is that when clicked it will not open, when I edit the hyperlink field [picky] the name is there (location) but the link path isn't. If I copy...