I am looking for a way for a user to be able to drag and drop 1 file to a row on a form.
When the file is dropped i want to run vba code that only needs the file name of the file that was drug to the control.
I am going to prompt them asking if they want to copy the file to the record.
If yes, then in vba, i am going to copy / rename the file into a different directory and then store the new relative path/filename with the record. (Note: I don't need it as a hyperlink, just the relative path / filename )
Any help would be greatly appreciated.