title: subform combobox rowsource update - how update drop down list
body: <p>I have a treeview control on an MS Access form. A subform combo box control's list of values depends on the node selected in the treeview on the main form.
  I am trying to achieve refresh of the combo box drop down list contents on the subform as follows:</p>
  
  <pre><code>Public Sub TreeView1_nodeClick(ByVal node As Object)
      subForm.Controls("Bid").RowSource = "... newquery depending on tree node values ..."
      subForm.Controls("Bid").Requery
  End Sub
  </code></pre>
  
  <p>But oddly enough, this does not update the list of values.
  A second click on the same node does update the list to the expected values; when another node is clicked the list again is wrong (it contains the list related to the next to last assigned rowsource, instead of related to the last one assigned).</p>
  
  <p>Is there some delay in activating the combo box' rowsource?<br>
  What is the solution for this obnoxious problem?</p>