title: Create a new record with certain values after updating an existing record
body: <p>I have a table "Payments" in Access 2013. It has the following fields </p>
  
  <p>DatePaid<br>
  DueDate<br>
  LeaseID</p>
  
  <p>What I am trying to do is this:</p>
  
  <p>When "DatePaid" is updated via a Form I need to create a new record in the "Payments" table with the same "LeaseID" as the one in the Form and fill in "DueDate" with the same day of the following month.</p>
  
  <p>For example:</p>
  
  <p>In the Table (Before Update) --</p>
  
  <pre><code>Record  LeaseID    DueDate   DatePaid
  ------  -------  ---------  --------- 
       1      123  11/5/2013   
  </code></pre>
  
  <p>On the Form --- </p>
  
  <pre><code>LeaseID: 123
  
  DatePaid: 11/4/2013
  
  [Submit]
  </code></pre>
  
  <p>Need the Table to Do This (After Form Entry) --</p>
  
  <pre><code>Record  LeaseID    DueDate   DatePaid
  ------  -------  ---------  ---------
       1      123  11/5/2013  11/4/2013
       2      123  12/5/2013
  </code></pre>