I have validation in the Before_Update event. Works great except for the unload of a form. <br>Scenario - <br>1) user changes data in a field<br>2) clicks the X on the form to close the form, triggering the unload event<br>3) prior to the unload event, the before_update event occurs<br>4) in this scenario, the user entered invalid data, the before_update event is cancelled (cancel = true) due to the validation<br>5) for some reason, the form_error event occurs - displaying a message box "You can't save this record at this time - do you want to close and lose your data?" (error 2169). If you click Yes, the form closes and all information is undone. If you answer No, the form redisplays with the data in it. This is the path I would like to take without having to deal the MS Access's not so <br>user-friendly at all. I tried to intercept to place my own message by setting the RESPONSE property of the form_error event to acDataErrContinue. The problem is - it takes the path as if you had answered "Yes" to the earlier question.<br><br>I would really like the data to stay on the screen giving the user the chance to correct the problem before exiting the screen.<br><br>Any insite would be greatly appreciated - this is one of those problems you just sit and spin your wheels on!<br>Thanks to anyone in advance!<br><br>Frustrated in New Jersey!<br>