Move files to directory specified in table

[dssjon]

I have figured out how to move files from the database current project path to another directory but I need help moving files to and from a directory that the user will specify in a table named tblPath. The user will simply enter a directory name in a field such as "c:\test" The goal is to use an access form that will facilitate the user in checking if files exist in specified directory, and if they do exist, move them to another specified directory. Any help would be greatly appreciated.

 

[lameid]

Without the specifics of the table, layout and how it relates to the form the best I can suggest is that you lookup the dlookup function and possibly read up on recordsets (more involved but more flexable).