Yes/No Data Macro Question? "NO" Click is not working

[mrmims]

Hello,



I have an inventory database with an "Expected Quantity" field. Whenever a user goes to change this field, a "Before Update" macro runs questioning if they are sure they want to changed this quantity. I am having issue when the user hits "no". How do I undo the change and have the value go back to its original when the user clicks "No". Currently I get an error message. This is what I have as my data macro:

If MsgBox("Are you sure you wish to change the Expected Quantity?",4)=7 Then 

RunMenuCommand 
UndoRecord

CancelEvent
End If

The Error Message I get when I click "No" is:

The command or action 'UndoRecord' isn't available now.

*You may be in a read-only database or an unconverted database from an earlier version of Microsoft Access
*The type of object this action applies to isn't currently selected or isn't in the active view

Use only those commands and macro actions that are currently available for this database

*Not working with a read only or an unconverted database
*Object is selected as I just changed the value and it is in the active view

As a side note, when I click "Yes" everything works swimmingly.

What am I doing wrong?

[ItsMe]

How about...

If MsgBox("Are you sure you wish to change the Expected Quantity?",4)=7 Then
me.ControlName.setfocus
Cancel = true
End If