Error - "Search key was not found..."

[Slez via AccessMonster.com]

I'm getting a strange error in one particular record. Somehow, a duplicate
record was created, and I cannot delete the record. I get the message "The
search key was not found in any record." It's an error 3709.

What might be my issue?
Thanks

 

[Tony Toews [MVP]]

I'm getting a strange error in one particular record. Somehow, a duplicate
record was created, and I cannot delete the record. I get the message "The
search key was not found in any record." It's an error 3709.

See the Corrupt Records in a Microsoft Access MDB page at my website
http://www.granite.ab.ca/access/corruption/corruptrecords.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/