-
I have a loop that runs through a Visual Data Manager database and sets the following text boxes to the given data. The idea here is to allow someone to edit the below info. Well How do I get to load some data back into a combo box. cboState is all the abbreviations for the 50 states. I can use it to add data, but I need to send it back to a new combo box and don't know how to do it. ANY IDEAS?
rsUniversity.MoveFirst
Do While Not rsUniversity.EOF
If txtSocial = rsUniversity(0) Then
txtLastName = rsUniversity(1)
txtFirstName = rsUniversity(2)
txtMI = rsUniversity(3)
txtDateOfBirth = rsUniversity(4)
txtStreetAddress = rsUniversity(5)
txtCity = rsUniversity(6)
cboState = rsUniversity(7)
txtZipCode = rsUniversity(8)
txtHomePhone = rsUniversity(9)
Temp = 1
End If
rsUniversity.MoveNext
Loop
-
<?>
I assume you are loading the information from a database into the textboxes and then the user can alter these textboxes and you load it back into the database and your question is how to get it back into a combobox.
Let's assume you want to load one particular field
Code:
rsUniversity.MoveFirst
While Not rsUniversity.EOF
combo1.additem rs!YourDatabaseFieldName
rsUniversity.MoveNext
Wend
