Prompt to Save Sub Forms

[topomni]

I have a Tab Page that has several subforms on them. Is there a way to prompt the user to save or rollback changes to the sub form information.

When I put the code to prompt the user to save data in the sub form, in the Before Update method, the message is called each time the tab changes.

There must be a way to reference the subforms from the main form to prompt the user to save.

 

[Pat Hartman]

Access saves the changed data in a subform every time the current record changes (including when the form is closed or loses focus). You don't need to prompt your users specifically to save. And if you want to prompt them so that you can give them the option of cancelling the save, you MUST do it in the BeforeUpdate event of the subform since that is the only place you can reliably cancel the uptdate.

So the short answer is no there isn't.