Hello
I am working with a VB6 form linked to MS Access db via Adodc connection. I have a combo box on the form. When I pick a value from the combo box, it writes the value to my Access db. However, if I exit the VB6 project, then load it up again and try to view the same record, the value I picked from the combo box is not there. But I checked in the table and it was written to the table. So I added a text box to the form, linked it to the same field the combo box was writing to, and there is my value. My question is, is there any way to show my values in the combo box. The combo code is:
Private Sub Form_Load()
Text3.AddItem "D-0"
Text3.AddItem "D-1"
Text3.AddItem "D-2"
Text3.AddItem "1/4 Keg"
End Sub
Any ideas are extremely appreciated.
Thanks
Jeremy
I am working with a VB6 form linked to MS Access db via Adodc connection. I have a combo box on the form. When I pick a value from the combo box, it writes the value to my Access db. However, if I exit the VB6 project, then load it up again and try to view the same record, the value I picked from the combo box is not there. But I checked in the table and it was written to the table. So I added a text box to the form, linked it to the same field the combo box was writing to, and there is my value. My question is, is there any way to show my values in the combo box. The combo code is:
Private Sub Form_Load()
Text3.AddItem "D-0"
Text3.AddItem "D-1"
Text3.AddItem "D-2"
Text3.AddItem "1/4 Keg"
End Sub
Any ideas are extremely appreciated.
Thanks
Jeremy