>I tyied to do the same with datalist and datacombo objects.. but didn't work, what code do i have to add ?
>
>Regards
>
>>>My Dear,
>>>It's working fine now... thank you very much.....
>>>
>>>but you didn't tell me why I should use .Jet.OLEDB.3.51 insted of ...4.0 ?
>>
>>It depends of the ADO version you have. If you have ADO 2.0, you need to use 3.51. If you have ADO 2.1 or more, you can use 4.0.
It is very close to what I already gave you for the grid.
Once your recordset is open, you can use this code:
With DataCombo1
Set .RowSource = rstData
.ListField = "FirstName"
.Refresh
End With
With DataList1
Set .RowSource = rstData
.ListField = "FirstName"
.Refresh
End With
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com