Ask cofirmation for changes on main- and subform

[John J.]

I use following code in my main form's beforeUpdate event for the not so
advanced users.

If msgbox("Do you wish to update this record?", vbYesNo) = vbNo Then
Cancel = True
Me.Undo
msgbox "The change has been discarded", vbOKOnly
End If

It works for the main form but not for the subform. I could add the same
code to the sub form too, but then the user may get the update question
twice. Would it somehow be possible to combine those 2 pieces of code into 1
so that a message only pops up once, when the user leaves the record on the
main form?
Thank you.
John

 

[Dale Fye]

John,

See the thread shown below for some discussion of this type topic.

date: 8/29/08
title: don't save subform data on form dirty
in :Access Database General Questions (microsoft.public.Access)

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

 

[John J.]

thanks
john

John,

See the thread shown below for some discussion of this type topic.

date: 8/29/08
title: don't save subform data on form dirty
in :Access Database General Questions (microsoft.public.Access)

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.