Deleted records keep coming back

[evanscamman]

I keep deleting record in a datasheet in a subform. I get the normal 'delete confirmation message' and the record disappears. But if I refresh the form, or look in the table it comes back.

I don't have any special code in any of the delete events. Any ideas why record is magically undeleting itself?
(I can delete it from the table - there is not a relationship problem.)

Thank you,
Evan

 

[evanscamman]

I just stumbled across the answer, so here it is in case anybody else ever needs it:

The query that was the data source for my table had a field in it that was from a second table. This was causing the record to not be able to delete - since it contained data from multiple tables.

Unchecking the column in the query allowed it to still function (criteria and sort) and reallowed deletions.

What messed me up is there is no error message, and the delete appears to have gone through. But then Access finds a problem, and seems to decide to do an 'on error resume next' for itself.

Evan

 

[emi]

I've just the same problem for which anything I tried became useless. Except the one that is to create a new query with the same structure BUT with a different name. It immediately worked.

Emre