I tried your suggestion about putting an Undo into the Before Event. It indeed lets me out of the textbox but it restores the value that was in the box before the user made a change.

So far the coding that seems to work is to have an Undo in the AfterUpdate event. It is inefficient because I am doing an I/O in the before event to update the data and then another I/O in the after event to undo the update. This may be the only choice...

Thanks again, your help is very much appreciated.

Just to make sure that I am explaining my situation correctly. I have a bound textbox on the form and the table has text data. In the field other than the Before Event I have nothing happening. My goal is for the user to enter/modify data in the various fields on the form and then at the end if they want to save the data to then press the save button and all the data then updates...

Thanks for the suggestion.

I have tried it, and unfortunately I wind up with the same problem. When I change a value in a text box with the Before Update logic present, the cursor gets "stuck" in that text box. The only way to move is to press "esc" so that the value goes back to what it was before the user changed it.

I have a form with a number of bound text boxes on it. When the form opens, it retrieves data from a table. I want the user to change data in one or more of the text boxes without any data from the form updating the table until the user presses a "save" button.

Simply, I want the user to see in the form the data that they want changed without it impacting the database in any way until a "save" button is pressed....