how to undo data on a parent form

[Ryno Bower]

I've got two forms called cashtransactions and cashtrndetail.

I have created a code that when the cashtransactions form open, it fills in data and then it also creates an autonumber in the one field.

On the subform cashtrndetail I have command buttons. The one is a close button. I am trying to write a code that if data was entered in any of the field in the subfrom and when I click the close command button then a msgbox appears saying that the details will be discarded and am I sure I want to close the form.

When I say yes to discard the details I want to undo all the data on the parent form and the subform and then close the form.

Can anyone please help!!!

Thanks
Ryno

[TheSmileyCoder]

As soon as you move focus to the subform, the parent form is saved. And if you have more then 1 record in your subform, the same goes when you move between them.

This means that technically you will not be able to do a undo, but have to delete your records instead.

Other option could be to use unbound forms, or bind both forms to temporary tables, and have some code in the unload event of the main form, in which you either transfer the new records to the main tables, or discard them.

[Adam Tippelt]

One thing to add to Smiley's idea of temporary tables is you'll still find that switching between parent form and subform will still save the record, even if it is saving it to the temporary tables instead.
One way to get around this is to have two global boolean variables, one that handles changes on the parent form, and one that handles change on the subform. So whenever a field on the parent form is edited, you tell it to set the first boolean variable to true. Whenever a field on the subform is edited, you tell it to set the second boolean variable to true.

When you come to checking if something needs saving, you can do a simple check to see if either of these are true, and ask whether the user wants to 'save' or not.

if (GMainChanges = True) or (GSubChanges = True) then<<<<YOUR CODE>>>> 'Set variables to false after you've finished.GMainChanges = False GSubChanges = Falseelse'Delete temporary records.end if

One variable is needed for each, because just as the main form is saved when you enter the subform, the subform is then saved when you leave it and enter the main form.

Adam.