title: visual basic Combo1.AddItem rs4("holding") wont work why
body: <p>the table name is water and it has two field fname and serial. in the field fname suppose a value 'bill' has 3 serial 1,2 and 3. now i need when i type bill in textbox1 and click search button, the combobox1 should show the serials of 'bill' are 1,2 and 3  .
  . m using ms access as db .m using the code but it not working. </p>
  
  <p>is there any other coding to solve this ?</p>
  
  <pre><code>Set rs4 = cn.Execute("select fname, serial from water where fname = '" &amp; Text1.Text &amp; "'")
  rs4.MoveFirst
  </code></pre>
  
  <p>Do While Not rs4.EOF
      Combo1.AddItem rs4("serial")
      rs4.MoveNext
  Loop</p>