title: Incorrect Syntax in code to filter subform
body: <p>I am trying to use an <code>AfterUpdate</code> event to filter a subform based on the selection in a combobox.</p>
  <p>For some reason I keep getting a error: <code>Run-time error '3075': Syntax error in string in query expression 'VendorID = 1&quot;.</code></p>
  <p>The code is:</p>
  <pre><code>Private Sub Combo104_AfterUpdate()
  
  Me.ProductSelectionSubform.Form.Filter = &quot;VendorID = &quot; &amp; Me.Combo104.Value &amp; &quot;'&quot;
  Me.ProductSelectionSubform.Form.FilterOn = True
  
  End Sub
  </code></pre>
  <p>Its nice and simple, but it keeps throwing that error. If I add a <code>'</code> in <code>= '&quot;</code> I get a a mismatch error.</p>
  <p>Where am I messing up with this?</p>