I have a DB app that has lots of textboxes tied to fields of a database, and three ADODC controls as the datasource. When the first ADODC1 control moves to the appropriate record, I use the MoveComplete event to navigate the second two ADODC controls to the correct record.
1) What is the difference between MoveComplete and RecordChangeComplete of the ADODC control?
2) I am using MoveComplete, is this the best event to use if I want to perform actions after the recordset has moved?
3) I am using this line of code to populate the caption of the ADODC1 control with the current record and recordcount. Yet, I've noticed that this line causes the ADODB.movecomplete to be called, so the procedure sometimes calls itself.
Adodc1.Caption = " " & pRecordset.AbsolutePosition & " of " & pRecordset.RecordCount
4) Is there a way to cycle through the recordset of an ADODC control without having to wait for each textbox to be populated for each move? I just want a value from each record in the recordset, then after I've goten my array of values, I want to reenable the ADODC recordset.