title: MS Access combobox rowsource target database
body: <p>I have an old access database which queries a central SQL Server that I am trying to work with.</p>
  
  <p>At the moment we only have one copy of this which points at the live database.</p>
  
  <p>I have made a copy of the access database and a copy of the sql database to try and create a test environment. While I have managed to nail all of the hard coded connection details on each form, I am unable to find the place where the combo boxes get ther data. we have code like this in the background:</p>
  
  <pre><code>cmbSeries.RowSourceType = "Table/View/StoredProc"
  cmbSeries.RowSource = "exec p_DispBoardSeries @Year='" &amp; cmbYear2 &amp; _
      "', @Board='" &amp; cmbBoard &amp; "'"
  cmbSeries.Requery
  </code></pre>
  
  <p>Can anytone tell me where the connection is set? I am stumped! Its still querying the live database!</p>