I have table in VB6 and want to put the Last name, comma, First Name in the drop down box on my form.
After I pull up the data from database, the Last name is located in field(2) The first name is in field(1)
Here is my code below for adding rec.Fields(2) to my dropdown box. I don't know how to also add the first name to the same line in my drop down.
Would it look something like this?
.AddItem rec.Fields(2), rec.Fields(1)
Do While Not rec.EOF