>I used the DataCombo from MS Data List component to display a
>list of column item from a Table.
>
>I only can specific a column to list, as shown below.
>Can I list more than one columns?
>
> dcTypeItem.ListField = "ItemColumn1"
If you want to continue to use this control, you have to concatenate fields in your SQL query (select firstname + ' ' + lastname as ItemColumns1 ...).
You can also use the combo box from the Forms components library (Add Microsoft Forms from Project -> Components).
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com