I have 2 datagrids on a form, each is connecting to separate Access tables
using ADODC data controls as datasources. The objective is for the user to
double-click on a row in one datagrid to remove it and to insert it in the
other datagrid (i.e. "move" it). This is done using .AddNew, followed by
.Requery for both ADODC datasources.

The problem is that it takes about 2-3 sec for the Access table to be updated;
but because the data is redisplayed immediately the datagrid still shows
the removed row. I tried putting in a Do loop to delay things: this works
most of the time but not a good solution. I also tried creating a RecordSetComplete
event but this doesnt seem to wait for completion either.

Any assistance would be greatly appreciated thankyou.