title: If/when with checkboxes in Access?
body: <p>Ok here's what I need help with in Access...</p>
  
  <p>Check boxes 1-5 are prerequisites for jobs listed like degree, years of experience etc.</p>
  
  <p>In check boxes 8-10 are the available jobs</p>
  
  <p>When reviewing someone's resume, we would check any boxes between 1-5 based on their skills. Boxes 1,3, and 5 are prerequisites for check box 8. Question is how do I auto-populate box 8 to automatically check if boxes 1, 3, and 5 are checked?</p>
  
  <p>Should I use the IIF function in the Control Source of box 8 or generate a query? What is a good example of the code that needs to be written? Thanks so much!</p>
  
  <p>T</p>