I have read heaps of webpages and help pages on how to declare a workspace, start a transaction using BeginTrans and cancelling it using Rollback. I can't get it to work.
I am using it as part of a form (containing a subform)
Dim wksp As Workspace
Private Sub cmd_Cancel_Click()
DoCmd.Close acForm, "frm_DebtorInv"
Private Sub Form_Open(Cancel As Integer)
Set wksp = DBEngine.Workspaces(0)
I've also tried
instead of using the wksp object variable.
I get no errors, but I can't get it to rollback the values
- The values of 3 bound controls in the form
and of many records in a subform (items on an invoice)