Table shows deleted record but it won't delete

[khughes46]

I have a table that is showing #Deleted in several fields, not all of them. When I select the record and try to delete it I get the message that the record id deleted. How do I remove this record?

[qa12dx]

use refresh or requery

[ranman256]

1. If is says DELETED it already is deleted. To NOT see that, close the table/query and open again. It should be gone.

2. If it STILL there, close database, compress.
(but it should not show once closed in step1)

[khughes46]

Compact and Repair did the trick. Thanks.