The attached has just the functions required and a button which should search subfolders and when it finds the pdf file should open it.
Let me know how it does?
Database10.zip
I've set the directory as a directory a level above where the PDF file is so if the file opens it has worked
Andy