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")