C
chasday
I am trying to use a command button on a form to delete the current record
displayed on the form. The record has several related fields in other tables,
but I believe I have successfully deleted all related records with delete
queries.
When I run the code
DoCmd.RunCommand acCmdDeleteRecord
the confirm delete message comes up, and after clicking through it the form
goes blank, appearing like a successful deletion. No error messages. However
the record is still in the table. In table view there isn’t any problem
deleting the record in question i.e. no related records.
I’ve tried using a wizard generated delete button with the same results.
Any ideas?
displayed on the form. The record has several related fields in other tables,
but I believe I have successfully deleted all related records with delete
queries.
When I run the code
DoCmd.RunCommand acCmdDeleteRecord
the confirm delete message comes up, and after clicking through it the form
goes blank, appearing like a successful deletion. No error messages. However
the record is still in the table. In table view there isn’t any problem
deleting the record in question i.e. no related records.
I’ve tried using a wizard generated delete button with the same results.
Any ideas?