Prevent Auto Saving

[teel73]

I have a main form ("frmMain") that includes 4 subforms. I want to prompt the user before updating the record with a basic msg "Do you want to save this record? Yes/No ... The problem I'm having is once I move the focus to one of the subforms the msgbox pops up. Does anyone have any other ideas of prompting before the record on the main form is saved? This is driving me crazy.

 

[John Big Booty]

Have you tired the Main form's Before Update event?

 

[teel73]

Yes. But when i move the focus to one of the subforms the before_update event is initiated.

 

[vbaInet]

That's normal behaviour, the changes need to be saved before moving to another subform.

If you want to handle this differently then you have to use an unbound form and code all the processes, i.e. update, insert, delete and other custom functions.

 

[teel73]

ok thanks.