This is somewhat of a continuation of my "Form field to update two tables?" post.
I was able to create a form/subform to update two tables. The parent form linked to the Gage Master table and subform to the results table.What I see as a potential problem is if someone inputs the dates on the parent form (which updates the subform) then moves to the subform to input data and changes their mind for some reason, there is no way to undo the date changes.
I am looking for some approach to enter the information with the ability to cancel.


One form I made used a combox in the header linked to the main table to select the gage, a subform for the results table and a subform within it linked back to the main table for the dates. The dates update within the forms but not into the main table. With this I was thinking if you cancel the results subform, then nothing would get changed.
I could use some help to point me in the right direction.
Thanks.