Alan,

> Luc,
> I don't want cancel because I will loose other fields entered before an
> attempt to post. And I want to be able to tell the user why I'm rejecting
> the record, but to give them another chance to correct their mistake.

You don't have to cancel - I just asked you to do so if you'd like to.
If you post the record and you violate the constraint/unique index the
query will stay in insert (or edit) mode as it was - no data will be
lost in the controls and you can tell the user what needs to be
corrected...

There's still no need to rollback the transaction.

Luc.