I have a main form with a subform in it that is used to enter notes. Nothing out of the ordinary yet. I have some text in the OnEnter event on the subform that will fill in some text if specific values are selected on the main form. That part works perfect. I noticed that after the text is added after the OnEnter event, if the user adds additional notes and clicks something that causes the form to lose focus, only the text the user entered is deleted. The record in the main form is intact, along with the text that is entered by the OnEnter event on the subform.

My first thought was the info in the subform is saved because of the loss of focus, however, that is not the case. Ultimately I would like the user to be able to enter notes, move away from Access if needed and be able to return to the same record if its open.