title: MS Access "record changes" log
body: <p>Whenever a record is deleted or updated on a form, I want to save its old values in a history table (let's call it Revised). I guess I have to do the following:</p>
  <p><em>For record changes</em>:</p>
  <ul>
  <li>use the BeforeUpdate event to save the data <em>somewhere</em> (collection ? array ? or to a recordset -the Revised table- without saving-yet ?)</li>
  <li>use the AfterUpdate event to add/save that data to the Revised table</li>
  </ul>
  <p><em>For Deletions</em>:</p>
  <ul>
  <li>use the OnDelete event to save the data - but again how ? several records could be deleted at once since the form (a subform in fact) is in datasheet view</li>
  <li>use the AfterDelConfirm to add that data to the Revised table.</li>
  </ul>
  <p>Do you have any clues, comments or links for this ?<br />
  This is all in a &quot;pure Access&quot; (no SQL Server) at the moment.
  Many thanks !</p>
  <hr />
  <p>Edit: as usual, properly asking the question gaves me ideas:</p>
  <ul>
  <li><p><strong>option 1</strong><br />
  use the BeforeUpdate or the OnDelete to build the SQL statement, and use the AfterUpdate or the AfterDelConfirm to Execute the SQL statement. But that won't work for multiple deletions ?</p>
  </li>
  <li><p><strong>option 2</strong><br />
  have the Revised recordset defined at form level, insert the record &quot;Before&quot; but only Update &quot;After&quot;. Again, problem with multiple deletes.</p>
  </li>
  </ul>