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

  • Thread starter Thread starter Isis
  • Start date Start date
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
 
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.
 
I use that technique with my wife.
She can't tell me to stop what she doesn't know I'm doing :)
 
Back
Top