Do not save changes button for form with a subform

[jle0003]

I have a form with a few combo boxes that also contains a subform with several other combo/text boxes. I added a "Cancel" button that should close the form without saving any changes made by the user. The problem is, it only works on the main form objects and not the subform objects. It will undo the changes to the combo boxes on the main form itself, but it will keep the changes made to the combo/text boxes on the subform. Here is the code I have for the button:


Private Sub cmdCancel_Click()
On Error GoTo Err_cmdCancel_Click

Me.Undo
DoCmd.Close
Exit_cmdCancel_Click:
Exit Sub
Err_cmdCancel_Click:
MsgBox err.Description
Resume Exit_cmdCancel_Click
End Sub


What else do I add to include the subform? Please help! Thank you!!!

[June7]

Doubt can be done, at least not without a lot more complicated code and saving 'old' values to a table and retrieving those values to re-edit the records back to the previous values.

Problem is, a record entry/edit is committed to table when move to another record, close form, or run code. I encountered this issue and gave up. I instead put a label in red letters on form warning users all edits would be saved regardless.

[jle0003]

I was afraid you would say that. Thanks anyway!

[June7]

Oh, I should have mentioned use of unbound forms might be the only alternative. Is the subform in continuous/datasheet or single view?

[jle0003]

Single view

[June7]

Then yes unbound form is option but again, need VBA code to save the new or edited record by using SQL update and insert actions.