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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repost: DoCmd.RunCommand acCmdDeleteRecord does nothing. 3
Problems when duplicating a record 7
Duplicating a record leaving one field blank for editing 6
cannot delete last record with code 1
How to Delete a Found Record in a Form 2
duplicate record except for primary key 2
Code quits after record delete 4
Need combo box to refresh when moving to new record 2017 1

Back
Top