Form & Sub Form

[Parra]

I have a form with Sub Forms and I would like to be prompted if I would like to to "Save" the record, before I can advance to the next one. That is if I have made changes to the record.

 

[Dugantrain]

Use the SubForm's BeforeUpdate event:

Your_Form_BeforeUpdate(Cancel as Integer)
If MsgBox ("Would you like to Save these Changes?", vbYesNo)=vbNo Then
  Me.Undo
  Cancel=True
End If
End Sub

and then, because no code has been written behind vbYes, the Record will be Saved and lose focus as normal.

 

[Parra]

Hi Dugantrain, I forgot to mention that there is one main form and 3 subforms. I would like the message to pop up for any changes in any of the 3 forms, if any changes were made.

Where should I enter the code, you said the sub form, but there are 3 of them.

Thanks, Parra

 

[TryingToLearn]

Same code should be entered in each of the 3 sub forms

HTH

 

[Parra]

OK, Great I added the code to the main form and the 3 sub forms and I think I got it to do what I wanted.

Thanks for all your help.

Parra