title: Update a text Field's value based on another date field passing a certain date
body: <p>For my Access database, I have a singular table with two fields - Award Status and Proposed Due Date. I want the Award Status to change to "Pending" once the Proposed Due Date has passed. </p>
  
  <p>Currently, I am writing VBA to have the field update once the criteria is met.</p>
  
  <pre><code>Function AwardUpdate()
  
      Dim rstInput As DAO.Recordset
      Set rstInput = CurrentDb.OpenRecordset("TestInput")
  
      With rstInput
          Do Until .EOF
              .Edit
              If .Fields(19) &lt; Date And .Fields(29) = "Pre-Submission" Then
                  .Fields(29) = "Pending"
                  .MoveNext
              Else
                  .MoveNext
              End If
          Loop
      End With
  
  End Function
  </code></pre>
  
  <p>But I can't seem to get the criteria to check for if the Proposed Due Date is less than the current date. </p>
  
  <p>Is there a better way to accomplish this?</p>