Hello everyone,
I am just learning MS Access.
I created a Main form (Name: StaffUsers ) and a subform (Name: CalJOBS subform).
I put the Undo button on the Main Form. However when I click the Undo button on the main form, the entered data are cancelled on the Main form only
and the entered data are still in the subform. I would like to Undo all data in BOTH Main form AND subform.
The following is codes I write (not working so far). I have a form CalJOB subform, should I call it CalJOBS or [CalJOBS subform]?
**************************************
Private Sub Cancel_Click()
With Me
Call .Undo
Call .CalJOBS.Form.Undo
End With
Call DoCmd.Close
End Sub
******************************
I appreciate any help.
Frank
I am just learning MS Access.
I created a Main form (Name: StaffUsers ) and a subform (Name: CalJOBS subform).
I put the Undo button on the Main Form. However when I click the Undo button on the main form, the entered data are cancelled on the Main form only
and the entered data are still in the subform. I would like to Undo all data in BOTH Main form AND subform.
The following is codes I write (not working so far). I have a form CalJOB subform, should I call it CalJOBS or [CalJOBS subform]?
**************************************
Private Sub Cancel_Click()
With Me
Call .Undo
Call .CalJOBS.Form.Undo
End With
Call DoCmd.Close
End Sub
******************************
I appreciate any help.
Frank