I am updating a database that was switched from 2000 to 2007 and i need help with getting the right path file. Here is the code:
If Nz(Me.tblCIFIStatus_subform.Form![Primary Req]) <> 0 Then
Set fs = Application.FileSearch
.LookIn = "\\Orl40038\shared\SYSMP\Job Description"
.fileName = Me.tblCIFIStatus_subform.Form![Primary Req] & "*.*"
Reqfound = .FoundFiles(1)
The problem with the code is that filesearch is not an appropriate function call anymore and i need a way to call the directory to get the single file and not do it recursively as most posts about application.filesearch are. So what i am asking for is if there is a way for me to look in the directory with a parameter as this case is primaryreq and search for that file in the directory.