>Nigel,
>
>ROLLBACK undoes the transaction but it does NOT clear the buffered edit. This gives you some additional control. You can either issue the TableReverts() or allow the user to try saving again later. If you don't do a TableRevert then the data buffers remain exactly as they were before the transaction started.
Thanks Jim,
That's what I've been doing but was intrigued that the help doesn't show that. I've not done much with transactions and have just picked up a task with problems updating so I'm converting to transactions.
BTW, I've just got some info on flights and should book one this weekend. I'll email you with details next week, thanks.