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

I

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
 
J

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.
 
K

Klatuu

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