I didn't realize that you were working with a new record. So is this the sequence?

1 -- transaction started
2 -- new record added to recordset
3 -- user modifies record
4 -- record is saved
5 -- user continues to modify
6 -- user cancels So, we want to roll back to (3).
7 -- transaction rolled back.

Am I following you? If so, why have step (4)?





>Thanks, Vin. Glad to see I'm at least producing reproducible problems.
>
>My only concern regarding issuing a requery is that I am working with a new, edited record. If I try to requery, I wind up with an empty record set, to which I must then append a blank, and rebind all of the UI controls (making sure that the blank values don't overwrite the user-provided values in the controls). Seems a bit slow at first glance, but I may wind up trying it anyway if no other option presents itself.
>
>Thanks for the response; I do appreciate the help.
>
> . . . . . . . -- Eric