James,
regarding IBO's ability to start a new transaction and return to the current
record...

Check out the
IB_Connection1.DefaultTransaction.Refresh(true);
method
and also the IB_Query RefreshAction property of raKeepDataPos

Alan