MS Access run code after a row is updated
<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>