>Hi,
>
>Thank for your help, for the datacombo box,
>is there any way to list more than one field
>like this
>
> cbodata.ListField = "VipCode & VipName" <======= this give error
>
>as the compiler report of error when I code the above statement
>insteads of only
>
> cbodata.ListField = "VipCode" <======== this is okay
>
You can't have 2 fields in a listfield but you can concatenate them in the SQL query (SELECT VIPCODE + VIPNAME AS NewField FROM ...) and use NewField into ListField.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com