title: how to filter on load in MS access?
body: <p>when double clicking on a value i need to open a form. the value gets passed to the opened form. I want the form to directly filter on that value instead of pushing on a button first. i tried filtering on change and on load but it doesn't work. when loading it doesn't know the value because it gets added after it opened the form.<br>
  this is the code for passing the value:</p>
  
  <pre><code>DoCmd.OpenForm "SubmenuRubrieken", acNormal
  Forms!SubmenuRubrieken.Tv_rubrieknaam.Value = Me.Tekst14.Value
  </code></pre>
  
  <p>this is the code for filtering on that value in Tv_rubrieknaam:</p>
  
  <pre><code> Dim filter As String
   filter = ""
   If Not IsNull(Tv_rubrieknaam) Then filter = filter &amp; " AND rubrieknaam = '" &amp; Tv_rubrieknaam.Value &amp; "'"
   Me.filter = Right(filter, Len(filter) - 5)
   Me.FilterOn = True
  </code></pre>
  
  <p>for some reason it doesn't trigger the filter on changing the value of Tv_rubrieknaam. how do i need to solve this?</p>