We have an Access database that has a subform and on this subform there is a fiield to first browse for a document and when selected will populate a field. A second option button is there to open the file (in this case always a Word document). The browse function works without fail, its just when I go to open the document. This has always worked in the past, but our move to Access 2007 has somehow broken this function. I will try to attach the code as an image.
When I click the button on the form, I get a message saying "The Directory Name is not valid".
(C:\Windows\System32)