adodc

Whats the best from a performance (If any differences) pont of view in populating a data combo. Using the adodc control component or ADODB.recordset code and looping through the recordset to populate my combo box?

Regards


Gerard

Neither, really. You should use a DataBound Combo with
an ADODB recordset instead, and bind it to the recordset
instead of looping through the records.

Code:

---


With myDataCombo
    Set .RowSource = myRecordset
    .ListField = "MyField"
    .BoundColumn = "IdMyAutonumber"
End With

---

Would I be better off using DAO, what I seem to here is that DAO still has better performance over ADO when accessing Access databases. Any comment?

Ta

Gerard