title: Update associated records when master table record is updated
body: <p>I'm relatively new to MS access and am seeking some assistance.</p>
  
  <p>I have a programs table (tblPrograms) and a history table (tblLog).</p>
  
  <p>On my edit program form (frmEditProgram) I want all historical records (tblLog) to update based on this change.</p>
  
  <p>Example:</p>
  
  <ul>
  <li>I have a program called "Cleaning".</li>
  <li>I open the Edit Program form, and change the record to be "Cleaning - Level 1"</li>
  <li>I want all records in tblLog that WERE "cleaning" to be updated to "cleaning - level 1"</li>
  </ul>
  
  <p>I understand this is probably extremely basic I'm just having difficulty putting this solution into a googleable question.</p>
  
  <p>I can't express how grateful I would be for any help!</p>
  
  <p>I'm lost as to where to start outside creating an update query, but I'm unsure the correct way to direct this.</p>
  
  <p>N/A</p>
  
  <p>n/a</p>