I have a main form with multiple Subforms that are all displaying Datasheet information related to the Main form record. When I make changes/adds to the records(s) in the subform and tab to another subform, it saves those previous subform records fine, but when I make changes to the subform records and then change the mainform criteria, it doesn't save those subform records.
I can use an event to prompt for saving the records on the BeforeUpdate event, but that asks that question on each record that is added in the subform. since there could be many records added at the subform, this isn't desireable. Does anyone know of a way to check the record(s) status before moving away from the subform so that changes are not lost?
I have tried to use the OnDirty and LostFocus events with no success.
Thanks
I can use an event to prompt for saving the records on the BeforeUpdate event, but that asks that question on each record that is added in the subform. since there could be many records added at the subform, this isn't desireable. Does anyone know of a way to check the record(s) status before moving away from the subform so that changes are not lost?
I have tried to use the OnDirty and LostFocus events with no success.
Thanks