title: MS Access run code after a row is updated
body: <p>I am very new to MS Access, forgive me for this simple question but I am very confused with my current problem.</p>
  
  <p>So I want to run a VBA function after a table receives an update on one of its fields. What I have done is:</p>
  
  <ol>
  <li><p>Create a Macro named Macro_update under CREATE->Macro, with action RunCode, and its argument is the VBA function I wish to run. The function has no bug.</p></li>
  <li><p>Select my table, and under Table->After Update, I wrote </p>
  
  <pre><code> IF [Old].[status]=0 And [status]=1 THEN
   RunDataMacro 
    MacroName Macro_update
  </code></pre></li>
  </ol>
  
  <p>But after I update my status field in my table nothing happened... I am suspicious of the fact that in step 2 my action is RunDataMacro, but I am actually running a Macro (is there a difference?)... any help is appreciated!</p>