> What I would like to happen:
>
> I don't mind that the transaction closes, but I
> want the data to remain displayed, and if they start
> editing it I want the transaction to reopen and work
> correctly and the data displayed to work correctly.
>
> What do I need to set to get those results?

Try setting CommitAction to caFetchAll. This will cause the
transaction automation to ensure that all records have been retrieved
so that it can safely close the physical transaction.

HTH

Geoff Worboys
Telesis Computing