stop saving when going from mainform to subform

[mainerain]

I have a mainform and a subform. If I make a change in a field on the mainform and then click onto the subform, then said change in mainform is saved. Visa versa, a change in a field on the subform is saved once I click onto the mainform.



I would prefer to not save in this manner but rather when I close the mainform I would get a prompt to save or not.

Thanks

[Micron]

That's how it's supposed to work. You could try using form BeforeUpdate event and cancel the update via a message box prompt I suppose. Info about that form event:
https://docs.microsoft.com/en-us/off...reupdate-event

IIRC, if you want to extend this to new records, you'll need the form BeforeInsert event.
EDIT - if you want to be able to change either form and not be prompted until you close the main form, then the only solution I see is to unbind both forms. A lot of code for not much payback.

[June7]

Code in BeforeUpdate events as Micron described

or

a single UNBOUND form and lots of code to load/save data from/to tables

or

two independent BOUND forms. Parent form would call the child form to open only after parent record is committed and then have to pass the key value to child form to save as foreign key in new records. Again, VBA will be involved but not as much as UNBOUND forms.

[CJ_London]

Your can also investigate using the begintrans, committrans methods

[mainerain]

You could try using form BeforeUpdate event and cancel the update via a message box prompt I suppose.

That's what I chose to do, thanks.