Does anyone know how I can undo changes based on after I trap a error and then allow the user to move on. Currently I have a Select Case in my Form_Error and I am able to trap the Error and then I END. But I need to somehow UNDO the changes and then allow the user to move out of the text box without triggering the error again. Some type of Cancel Event I think or something. Any ideas?

Undo is the key word here. Search help for Undo to see how this can work for you. If you are using Access2000 you need to search for Undo while in the VB window. If you still have problems then post your code so we can see what you are doing....