After checking on an update - stop user proceeding on a condition

[Isis]

John kindly gave me a way to check on the existence of a file
that the user is inputing - if the test fails - the file does
NOT exist - I want to stop the user proceeding with the add and
maybe clear the form ?

Any ideas on this would be great.

Thanks

 

[Guest]

Look in VBA Help for the Dir function. It will get you what you need.

 

[John Spencer]

Isis,
Do you have some code you can share?

If you just want to stop the procedure it could be as simple as

If Dir(strFilename) = "" then Exit Sub ' or Exit Function

We don't know what you are doing so it is hard to tell you how to stop.

 

[Guest]

I use that technique with my wife.
She can't tell me to stop what she doesn't know I'm doing