ODBC; docmd.apply filter creates new record after delete

  • Thread starter Thread starter david epsom dot com dot au
  • Start date Start date
D

david epsom dot com dot au

DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdDeleteRecord
DoCmd.ApplyFilter , "idxID= 114"

I start with 16 records: after the 2nd line I have 15 records: after the
third line I have 16 records. Record 114 already exists. idxID is the
primary key Identity (autonumber) field.

The new record is not current. There are no required fields without default
values, so I am not getting an error.

Has anyone seen anything like this?

(david)
 
acCmdDeleteRecord moved the form to a new (blank)
record.

A value was written to the record in the form
current event.

The record was automatically saved when the form
moved to a different record.

(david)
 
Back
Top