title: How do i set values based on other values when database opens
body: <p>I am trying to get the status of my jobs to change automatically when the database opens. </p>
  
  <pre><code>If Me.STATUS = 6 And Me.UPDATED_TIME = Date - 1 Then
      Me.STATUS = 2
  Else
  End If
  </code></pre>
  
  <p>that is my current code however it doesn't seem to be working...
  help please!</p>