Hello everyone, would you please help me to solve my problem...

I just wanna know how does Access done all the things. Everytime user click the 'add record' navigation button Access will go to new record, but if they click the else navigation button (ex: previous, next, last, first) Access will cancel the new record without having any errors (if user didn't make any changes for the table that have primary key). Was Access use Transaction methods (ex: BeginTrans, CommitTrans, RollbackTrans)? But Access Form has AfterUpdate event so how to commit or rollback the transaction? Or everytime user click the else navigation button (ex: next, first) after the they click the add record navigation button Access will delete the new record.

Thanks for any helps. NB: Sorry my bad english.