Save Button with If Msgbox

[data808]

I have a save button with an "if msgbox". If the user clicks yes the save will go through. If the user clicks no then the record is undone. Instead of undoing the record, I would like to just keep the record dirty and prevent the save. Is this possible? Is it the cancel event or something? If so, how do you write that in VBA?



Thanks.

[June7]

Post your button code.

You need an If Then Else, like:

If MsgBox("Do you really want to save record?", vbYesNo) = vbYes Then
DoCmd.RunCommand acCmdSaveRecord
End If

Be sure to disable form X close and right click menu.

[data808]

Post your button code.

You need an If Then Else, like:

If MsgBox("Do you really want to save record?", vbYesNo) = vbYes Then
DoCmd.RunCommand acCmdSaveRecord
End If

Be sure to disable form X close and right click menu.

Thanks June7. I figured out to use the Cancel = True line to prevent the save where needed. Seems to be working the way I want. Thanks again.