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
Printable View
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