Dumferling
Member
- Local time
- Today, 19:26
- Joined
- Apr 28, 2020
- Messages
- 102
I cannot delete a record from a form or a query. I thought it might be at the query level so I opened the query and attempted from there. It appears to delete fine (asks for confirmation and the record disappears) but if I requery then the record reappears. I can add new records with the query so I understand that the query should allow me to delete. If I try to delete at the form level it runs a vba confirmation check that I want to and then doesn't actually delete. There are no error messages, just a failure to delete. Any suggestions on where to look to find out what the issue is? I can't find anything that indicates what I am doing wrong. I am using DoCmd.RunCommand acCmdDeleteRecord as the delete code.