title: Check record based on criteria in multiple related records
body: <p>Let me start with the structure.</p>
  
  <p>I have a <code>Class</code> that has many <code>Experiences</code>.</p>
  
  <p>The <code>Class</code> can only be cleared if all the <code>Experiences</code> have been cleared.</p>
  
  <p>The <code>Class</code> and <code>Experience</code> share an <code>Experence_ID</code> This ID is not unique to an <code>Experience</code>.</p>
  
  <p>For example, if I run <code>'DoCmd.OpenForm "Experences", , , "[Experence ID] = '" &amp; Me.Experence_ID'</code> from the 'Class' I can get more than one record.</p>
  
  <p>What script could I use to check if the <code>Experence_Cleared</code> is checked (it is a checkbox field) in each <code>Experience</code> record that has the same <code>Experence_ID</code> as the <code>Class</code>?</p>