I have a user that would like a button that opens a window into a particular folder. No problem there, I used this:
Call Shell("explorer.exe " & QPathFile, vbNormalFocus) - the QPathFilename is the folder directly path.
Now this user wants to be able to select the file in the window and have that name populate a field on the access form. I know if they doubleclick on the filename it will open the file. That is fine by him but he wants the name to go into the field.
Any ideas or do I just have to tell him to do a copy and paste from the window?