update after vba code

[alxj]

I have a text box which is bound to an underlying table. I used code written in vba to make this box fill from the data of one in a subform within the main. The answer is shown correctly in the text box and correctly updates the underlying table but only after you click in the text box and then click somewhere else.
My [Event Procedure] is currently in On Exit .
Is there a way of making it self update like if you enter the code directly into Control source??


Alex