I have two datagrids on a form, each using their own adodc control.
In the _AfterColUpdate event handler on the first datagrid, that cell's information is used to update a row or two in the table behind the 2nd datagrid (via .execute sql on the connection). Using .refresh on the second adodc and datagrid has no affect with respect to the newly changed data until after the thread producing that change has terminated. (E.g., after a breakpoint has broken the flow on that thread, or running the .refresh statments from a command button after the thread is terminated.)

This is a "generic" problem I have had often in similar situations that involves use of bound controls and programmtic modification of DB tables. (DoEvents has no effect in these situations.)

Is there an event further in the flow of such in which the .refresh commands on the second datagrid would have an effect?
Is there some other way of implementing the refresh?
(Hopefully, something better than putting the .refresh code in something driven by a timer. [Argh! Perverse, late-night thoughts.])

I have experienced so many variants of this issue through the years, it would be really nice to find an elegant resolution. Also, it would be really helpful to find a good description of the underlying processes involved, and what one can do to keep things better synchronized between the database and the controls.

Thanks, in advance
Jim