Navigation buttons???

  • Thread starter Thread starter Sheldon
  • Start date Start date
S

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
 
After you set Cancel=True, put in these two lines of code:
Me.Undo
Me.Recordset.MovePrevious
 
Back
Top