Hi,
The actual record is dirty and CANNOT be saved because it violates a
rule or a data integrity relation. Moving to another record will disregard
the actual modifications. Use Me.Undo, under a form, to undo all
modification, explicitly, before moving to another record, if you don't mind
to lose the modifications.
Hoping it may help,
Vanderghast, Access MVP