Reset original values with Calendar Control (1 Viewer)

I have a form with a calendar control, tied to a table that holds the date selected, and it works correctly. However, if the user clicks the Cancel button,which closes the form, the date selected on the control has already replaced the date that was in the table before opening the form. I'd like the date in the table to remain at its value before the calendar control updates when the cancel button is pushed. Any suggestions?

Why not try setting an unbound control on the from which on open holds a copy of the data in the form AND another to hold the default date from the calender control.

Then in the cancel button event test for each value using IF statements and then take the appropriate action of setting the value back to its original value if the user cancelled the action

Hope that made sense

Ian