title: Access Dropdown to filter subform
body: <p>Apologies if this has been answered but being new to access i cant see what will help me,</p>
  
  <p>I have a access form that as a subform in it that displays an engineer name and a tickbox to select when logging downtime for the engineering team. however there is 4 teams and they are generally getting bigger which now means we have to scroll through the names to get to an engineer we want. </p>
  
  <p>I have a list of all the engineers and what team they are associated to on 1 table and on the main form there is a dropdown with the teams on. When i select a team from the dropdown i want the subform to filter out any engineers that dont belong to select team.</p>
  
  <p><strong>Additional Information</strong></p>
  
  <p>Subform_SelectEngineer</p>
  
  <p>Dropdown name is TeamFilter</p>
  
  <p>Hope this is substantial information</p>