Hi,<br><br>I have a data grid on a form which connects to a sql7 table via the dataenvironment. Initially the data grid is read only, but I allow the user to edit the data (via cmdbutton) and I then set allowupdates and allowdeletes to true.<br><br>The user then has to press an update button to commit their changes or cancel not to.<br><br>The cancel button works if the user amends data, but it fails if the user deletes a whole row (ie selecting the row on the left side of the grid, highlighting it and then pressing delete)<br><br>Im using the following command for the cancel button:<br><br>DataEnvironment1.rstDirectMail.CancelUpdate<br><br>So my question is, is it possible to reverse a deletion and if so how.<br><br>Cheers,<br><br>Ray.