We recently updated our
Terms and Conditions for TechRepublic Premium.
By clicking continue, you agree to these updated terms.
Invalid email/username and password combination supplied.
An email has been sent to you with instructions on how to reset your password.
Welcome to TechRepublic!
Username must be unique. Password must be a minimum of 6 characters and have any 3 of the 4 items: a number (0 through 9), a special character (such as !, $, #, %), an uppercase character (A through Z) or a lowercase (a through z) character (no spaces).
As opposed to the MS Access DBCombo, the combo box delivered with VB6 does not automatically fill a list with more than one field. You have to do this manually.
What I do is get the fields from the recordset that I want to show in the combo and assign them to a variable. To do this you need to create a loop on the recordset in order to get the fields for all records:
There are other ways of doing this such as using a combo in conjunction with a list box and then hooking the list box up to the combo, where the list box is not visible and when the combo box isclicked, it doesn’t drop down, but instead the list box becomes visible.