title: Function won't give revised results on changed parameter
body: <p>I have a form that includes the following:</p>
  
  <pre><code>Public Function NumDisc() As Integer
  
  NumDisc = DCount("*", "tblDisclosure", "Not IsNull(ReachedDBS) And ReachedDBS &gt;" &amp; MyDate)
  
  End Function
  </code></pre>
  
  <p>‘MyDate’ is an unbound control. The form’s OnLoad event makes it twelve months ago (Date-365). </p>
  
  <p>The intention is that on load a text box gives the number of applications sent to the DBS over the past twelve months.</p>
  
  <p>On Loading the form the text box gives the correct number.</p>
  
  <p>What I can’t do is get it to recalculate the number of applications from a different date. I have tried Refresh, Requery Repaint and the text box only ever shows the twelve month figure. </p>