Deleting Record on Form Does Not Work

[MatthewR]

Hi, all. So, I have a form with a record for each client. And when I use the record selector to delete a client, the client's record initially disappears just as I would expect. But, when I close the form and reopen it, the client's record is back. So, it was not deleted after all.

I suspect it has something to do with the fact that the form's record source includes the parent table tblClientInfo, as well as a related child table, tblNext.

But I still don't know how to fix the problem. I want to make it so that deleting the record actually deletes the client, and cascade deletes data in all child tables.

I've attached the db. The form in question automatically opens at startup. Please let me know how to fix. Thank you!!

Dom's Database Revision.zip

[CJ_London]

I suspect it has something to do with the fact that the form's record source includes the parent table tblClientInfo, as well as a related child table, tblNext.

you suspect correctly. The rule for forms where you expect to be able to edit data (including deleting) is one table one form.

[RuralGuy]

What exactly are you doing to "delete" the record?

[June7]

tblNext should be in a subform, same as you did with tblActivity.

[MatthewR]

Good call. I made tblNext into a subform so that the main form could be based on just one table. Now, deleting records works just fine. Thank you!!