Determine if file exists before creating file

if "merge" is a directory, i suggest u do this:

Code:

---

If Dir("C:\" + (CStr(Forms!Foreclosure!MJUNumber))) & "\" & ((CStr(Forms!Foreclosure!MJUNumber)) + "merge", vbDirectory) = "" Then
Call MsgBox("File Already Exists!")
Else

---

if "merge" is a database file, include the extension ("merge.mdb")

try first to check the result of the string if its a valid directory

Code:

---

Msgbox ("C:\" + (CStr(Forms!Foreclosure!MJUNumber))) & "\" & ((CStr(Forms!Foreclosure!MJUNumber)) + "merge")

---