Record movement being cancelled

[Rob]

Hi all,

In my Form_BeforeUpdate I have the following code:

If MsgBox("Save changes?", vbQuestion + vbYesNo) = vbNo Then
Cancel = True
Me.Undo
End If

If the user is using the default Record Navigation buttons, and moves to
the next record, the event fires (as expected). If they press No nothing
happens and the form is undone, if they press Yes the record is saved,
however they do not move to the next record. Is record movement being
'cancelled' by interrupting the BeforeUpdate event? I have had a look
through the access help file and

 

[AccessVandal via AccessMonster.com]

A simple test on your code works find, it will move to next record.

You might have events, controls or validations in that form which is
preventing it from moving to the next record.

Rob wrote:...snip