title: Form load and filter question
body: <p>I'm doing a search form. On top, there are several comboboxes for users to choose a combination of criterias. Then I construct a Where string to filter a sub form displaying the results.</p>
  
  <pre><code>Me.sub.SourceObject = "subResultType_1"
  Me.sub.Form.Filter = strWhere
  Me.sub.Form.FilterOn = True
  </code></pre>
  
  <p>This code is in the "Search" button's click event. </p>
  
  <p>The problem is, when <code>Me.sub.SourceObject = "subResultType_1"</code> is executed, the subform will display all the records. Then it gets filtered. But what I want is the subform displays nothing until it gets filtered. This is because my program will be used as front/back end on the rather slow network.</p>
  
  <p>PS: I think when a SQL clause with the WHERE part, or a form with filter, it gets filtered on the back end. So only a little amount of data will be transmitted on the network to the front end. If I'm wrong on this, tell me...</p>