My MS Access application links to several oracle tables. I have form which connects to one of these tables for the users to be able to edit data and also add new records. The issue i'm having is when a user choses to add a new record and then decides to exit the form with out filling out some of the required fields MS Access displays an error something to the extent that some required fields are missing. I would like to display my own custom message, I tried doing a validation check with with form Unload and OnClose events but, the error comes up before these events are fired. Any suggestions?