I have a form that the user populates, they then click button to move to another form to add additional data but the original form stays open (I need results from the 2nd form to be included on the first form before the record is saved.)
However if the user needs to cancel out without saving changes I need both forms to close cancelling any changes. I can do this to the form that had the focus but I can't seem to close the original form without saving changes. The record that is displayed on the original form isn't put into the table when the user moves to the 2nd form so I assumed the normal Me.Undo would work but it doesn't! Any ideas? I did think about the delete record query but as the record isn't yet in the table I don't think this would work?
However if the user needs to cancel out without saving changes I need both forms to close cancelling any changes. I can do this to the form that had the focus but I can't seem to close the original form without saving changes. The record that is displayed on the original form isn't put into the table when the user moves to the 2nd form so I assumed the normal Me.Undo would work but it doesn't! Any ideas? I did think about the delete record query but as the record isn't yet in the table I don't think this would work?
