Hi guys,

Hopefully real simple. When creating a new record in a form and it fails data validation, i get the following errors

1 - Validation Text
2 - Access warning about closing without saving
3 - Macro Stop error (Because i'm using an exit button, can ignore this)

Ideally, i'd like to only show error 1 but just as happy with errors 1 and 2. How can i handle error 3 so it doesn't show. I think i remember an If error Macro?

As always, many thanks for any help provided, cheers