In Access VBA, I'm having trouble getting my BeginTrans, CommitTrans, and Rollback to work.

I don't know where to start to explain what I'm doing that might be causing the problem, so I uploaded it onto my server so you could d/l it and look at it:

Click here for the file

I'm having problems with frmWB. I want it to act like a document that is only changed if it is saved. If the db is closed without saving, the changes are dropped. I use BeginTrans on Form_Open and I use either Rollbacck or CommitTrans on cmdClose_Click.

Thanks for looking.