Ah, you're storing the file names with the extension, remove the
& ".docx"
from the code.
Calling Module from a form.
Competent Performer
Windows 8 
Access 2016
Ah, you're storing the file names with the extension, remove the
& ".docx"
from the code.
Expert
Windows 10 Access 2016
The same error returns when I call it from the form.
As you said. If the control name on each form is the same, and the field name in every source is the same. Even though the field name and control name differ, I can use the same phrase from the Module.
Competent Performer
Windows 8 Access 2016
Same error with post #61 applied? I opened your form again and you're storing files as filename.docx, since the code also adds .docx, it was trying to open filename.docx.docx, which is wrong
Expert
Windows 10 Access 2016
That is fantastic. It works. Another lesson learnt. You may marry my stunning 35-year-old daughter now.
Competent Performer
Windows 8 Access 2016
Haha, I appreciate the offer, let me know what else I can help with, I'm glad it works now
General module calling public function in an open form
Calling A Module Function To Open A Form
Posting Permissions
Reply With Quote