>>Jim, I don't quite understand how transaction may wrap Valid event, but anyway use LostFocus event instead of Valid, especially if you use VFP3.
>
>Hi Edward,
>
>Actually the transaction isn't in the Valid Event but rather the form that the TextBox resides is in a transaction. The form is used to enter one record so the init of the form has a begin transaction and the save/exit button has the end transaction (there is also an exit without save button, which has rollback.) Sorry for the poor description, hope this helps.
>
>I'll see if I can get better results with LostFocus.
The general purpose of transaction is to combine several data updates together. I guess that the only place where you actually change data is cmdSave.Click routine, so you may put both BEGIN TRAN/ROLLBACK there.
Edward Pikman
Independent Consultant