title: Loop table rows in Access, with or without use of Private Const
body: <p>I am doing some VBA programming here, and I have a <code>Private Const</code> with two elements as follows:</p>
  
  <pre><code>Private Const myList as String = "foo;bar"
  </code></pre>
  
  <p>I then have a looping structure like this:</p>
  
  <pre><code>myTerms = Split(myList,";")
  For I = 0 to UBound(myTerms)
     'do stuff in here
  Next I
  </code></pre>
  
  <p>Finally, here is the new part.  In tblWords there are 100 different row, consisting of simply an ID field, and a text field such as <code>tblWords.ID</code> and <code>tblWords.Word</code>.</p>
  
  <p>My question is:  Instead of using the <code>Private Const</code> and looping twice, how can I modify my loop so that it will instead loop over the <code>tblWords</code> 100 times, once for each row? </p>