pick up file from directory 1

[YanaD]

I need to have a search of a file in 1 directory of 500 files. In my recordset i select a file name(041001.pdf) and i have to search for this file in the appropriate directory where 500 files located with different file names.

 

[gcole]

Try the FileExists function

 

[tcoffey]

Try using the "DIR" command and put the name of the file you are looking for in it. The number of files should not matter. After you put you filename in the DIR command check and see if the legnth is > 0 it so then the file exist.