I want to be able to create a database combo box in which I use a value list instead of referencing a table. I'm able to do this in Access but haven't figured out how to do it in VB6. I have a form with several combo boxes and I simply want the user to select either "Yes","No","UTD". However I want that value reflected back to a field in the table. Because I will have so many combo boxes on my form I don't want the user to have to open up a table each time they select from the combo box. Any help will be appreciated. I tried the AddItem method on FormLoad but the values don't end up in the table.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Create value list for combo box
- Thread starter Terpsfan
- Start date
Have you tried to use the ADO data controls ? Combo boxes can be easily tied to these controls.
You ADO control will take care of retrieving data from the database and your combo box can be used to display these values.
- Subha
Nothing is impossible, even the word impossible says I'm possible.
You ADO control will take care of retrieving data from the database and your combo box can be used to display these values.
- Subha
Nothing is impossible, even the word impossible says I'm possible.- Status
Similar threads
- Locked
- Question
- Question