Robert,

Here is a simple function to check file/directory existence that you should
be able to use

Public Function IfExists(FileName As String, Optional Directory As Boolean =
False) As Boolean
Dim sFile As String
If Directory Then
sFile = Dir(FileName, vbDirectory)
Else
sFile = Dir(FileName)
End If
IfExists = sFile < ""
End Function

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Robert Couchman" wrote in
message ...
Hello,

yes you people will know my project inside and out soon!
i am looking for a way of creating a form that will allow
me to search through my files and when it finds the file i
am looking for it will open all the details in another
form.

i would also like to be able to edit this data if needed.

all the data for the people are on the same row,
each row is individual to the person.

any help, please let me know!

Thank you,

Robert Couchman