title: Event Driven Data Macro to Calculate Field in New Record - MS Access
body: <p>In MS Access 2013 I have a table called <strong>[Serials]</strong> which consists of only 3 columns: <strong>[ID]</strong>, <strong>[Hashed ID]</strong> and <strong>[Product Description]</strong>.</p>
  
  <p>[ID] is an Incremental Integer Autonumber, and the Primary Key. [Hashed ID] holds the result of a Hash Function applied to [ID]. Finally, [Product Description] holds user input (the Hash Function is stored in a VBA Module as a Public Function).</p>
  
  <p>What I would like to do is to have the field [Hashed ID] calculated automatically after a row is inserted on the [Serials] table.</p>
  
  <p>I guess that the trick lies in correctly using the Event Driven Data Macros for this table, but I've only managed to make this work using the "Before Change" event on rows that had already been inserted (Therefore, with a saved value on their [ID] field?) . I'm lost!!!</p>