Data Combo and Looping from database

I am new to VB and I have been having this problem. (I am using VB6)

This question has 2 parts.

1 - I Have a form on which there is a combo box and a Data Control. The Data Control is connected to the database. The database name is Labels, the table name is Products and the column is Products. I want to pull all the info from the Products column and place it into the combo list. My problem is that I have not been able to code in the loop so that it selects all the rows from this particular table.


2 - I was wondering how you can autofill a data combo box in VB 6. So if a user clicks on the combo box and they start typing it will automatically go to the selections typed in. Example: A user is looking in the combo box for a value of 'SAUSAGE' and they type in 'S' it will go to the S's and then if they hit 'A' it will go to 'SA's and so on.

1h$‚ÜÞèÐÊä@èÐÒÜÎ@èÐÂè@òÞê@ÚÒÎÐè@îÂÜè@èÞ@ØÞÞÖ@Âè@ÒæX@îÐÊÜ@ Â@ê
æÊä@ÆØÒÆÖæ@ÞÜ@Â@ØÒÜÖ@îÐÒØÊ@Òè@Òè@ÒÜ@òÞêä@àäÞÎäÂÚX@Òè@ÞàÊ� �æ@Ò
è@êà@ÒÜ@Â@ÜÊî@ÒÜèÊäÊÜè@ÊðàØÞäÊä@îÒÜÈÞîX@ÜÞè@òÞêä@àäÞÎäÂ� �@æÞ@
ÒÌ@Òè@îÂæ@Â@ØÒÜÖ@èÞ@ÂÜ@ÊÜÆäòàèÊÈ@àÂÎÊ@èÐÊ@êæÊä@îÞêØÈ@ÐÂì Ê@èÞ
@ÎÞ@ÄÂÆÖ@èÞ@èÐÊ@æèÂäè@ÞÌ@èÐÊ@ìÄ@æÒèÊ@ÂÜÈ@èÐÊÜ@ÜÂìÒÎÂèÊ@è� �@èÐ
Ê@àÞæè@èÞ@ÈÊÆäòàè@Òè@P’@èÐÒÜÖ@èÐÂè@òÞê@ÜÊÊÈ@èÞ@àêè@ÂÜ@ÂÈ� �äÊæ
æ@ÄÂä@ÒÜRZøZ@êäÎÐ@ZøZ
^7*

Code:

---


rsProduct.MoveFirst
cboProduct.Clear
Do
  cboProduct.AddNew rsProduct!Product
  rsProduct.MoveNext
  if rsProduct.EOF then exit do
Loop
cboProduct.ListIndex = 0

---