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.