adodc

[gerard]

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

[DrewDog_21]

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.

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

[gerard]

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