Godfrey,

<< The transaction fails and rolls back but the code I included within the
transaction to trap theduplicate record error does not execute(it should
cancel the append and raise an exception). I do not get a exception
immediately but only afterwards if I try and move or add another record. As
you can see from my code the record is posted and then rolled back by the
transaction. >>

Is it at least executing the except block ?  IOW, are you sure that you've
got the correct section of code and that you've stepped through it in the
debugger ?

--
Tim Young
Elevate Software
www.elevatesoft.com