Navigation buttons???

[Sheldon]

I have a form with a navigation button. I can easily use
the cancel = true in before update event to prevent update
of the record. But the record stays on the screen. The
record does not change.

As an example, If I decide to create a new record, then
change my mind, by exiting or going back to a previous
record, I would set cancel = true, but it stays on the
same record. How do get off tthe current record?

Thanks

 

[Ken Snell]

After you set Cancel=True, put in these two lines of code:
Me.Undo
Me.Recordset.MovePrevious