Paul,
Actually, that makes sense now that I think about it. And it's much less of a kludge than the other thing we came up with. Glad you got it working!!!
~~Bonnie
>Bonnie:
>
>I spoke to soon. If I put EndCurrentEdit on the Leave event of the text box the RejectChanges works for all records.
>
>Thanks for the clue on the AcceptChanges, it helped out!!
>
>--Paul