PDA

Click to See Complete Forum and Search --> : Data Combo and Looping from database


AntonS
Jun 28th, 1999, 10:49 AM
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.

hurgh
May 2nd, 2001, 07:11 PM
1h$@@@@@@@@@X@@@
@@@@@@@@@@X@@@
@@@@@@@X@@@@@
@@@@@@@@@@@@@
@@@@@@@@@@@@@@
@@@@@P@@@@@@@@
@@RZZ@@ZZ
^7*

Jethro
May 2nd, 2001, 07:56 PM
rsProduct.MoveFirst
cboProduct.Clear
Do
cboProduct.AddNew rsProduct!Product
rsProduct.MoveNext
if rsProduct.EOF then exit do
Loop
cboProduct.ListIndex = 0