Edit Mode in Tabular Views...

[Scott]

How do you get a record out of Edit Mode in a tabular
view so you can delete a duplicate entry that already
exists in the table?

The evaluation can't take place until Access lets you out
of edit mode because the record is not comitted until you
are out of edit mode.

The problem I have is that I can move to a different
record and return to the current entry, but it disrupts
the tab and entry keys and sets the focus back to the
previous when I want the tab and enter to continue on
their course.

I simply want the entry to be comitted, edit mode to be
set to a selected record, and the tab and and entry
course of action to continue.

Any of you have an idea?

Scott

 

[Graham Mandeno]

Hi Scott

You can save the current record with either:
DoCmd.RunCommand acCmdSaveRecord
or
Me.Dirty = False

Or, you can undo changes to the current record with:
Me.Undo