Commit changes? Yes/No/Cancel

In Forms 3, if a block is cleared with changes pending, a dialog box pops up asking whether changes should be commited, with options of Yes, No or Cancel.

This is giving us synchronisation problems when we have two detail blocks to be committed in conjunction.

Specifically, if user says commit on clearing the first block, then all the changes in both blocks are committed, and everything works. If they say cancel on clearing the first block, then the first block is not cleared, and code can detect this and abort.

So far, so good...

If they say No to committing the changes in the first block, then that block is cleared, and processing continues to the second block. Since this is uncommitted, the dialog box reappears, and the user is allowed to commit the changes in this block.

Does anyone have a mechanism for determining whether the user answers No when asked if they want to commit their changes?

--
  _________________________   _________________________________________
 /  Tommy Wareing          \ /  And I dream of movies                  \
|  p0070621_at_brookes.ac.uk   X   They won't make about me when I'm dead  |
 \  0865-483389            / \      - Jon Bon Jovi, Keep the Faith     /
  ~~~~~~~~~~~~~~~~~~~~~~~~~   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~