title: Filter subform based on combobox in main form
body: <p>I'v got this code:</p>
  
  <pre><code>Private Sub Kombinationsboks3_Change()
     Me.Tilmeldt_underformular1.Form.FilterOn = False
     Me.Tilmeldt_underformular1.Form.Filter = "[Afdeling]= 'Ansøgningsafdelingen'"
     Me.Tilmeldt_underformular1.Form.FilterOn = True
  End Sub
  </code></pre>
  
  <p>In stead of the field [Afdeling] being equal to a specific text, I need it to be equal to the value in the combobox on the main form Form_Afdelinger.</p>
  
  <p>I've tried searching around, but I can't seem to find the answer, so I'm hoping one of you can help me.</p>