Error 3709

[Guest]

Hello.. When deleting a record (from a command button on a form), I am getting the Access (2002) error message: "Error 3709 The search key was not found in any record". The record DOES delete, but I have been unable to track the reason for the error message. Any suggestions?

 

[Lynn Trapp]

Click on this link copy and paste it into a browser. it will take you the
the results of a search on the error you received. You should get about 8
hits. Check those articles to see if there is anything that might give you a
clue to yourproblem.

http://support.microsoft.com/search...L&maxResults=25&Titles=false&numDays=&InCC=on

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

Hello.. When deleting a record (from a command button on a form), I am

getting the Access (2002) error message: "Error 3709 The search key was not
found in any record". The record DOES delete, but I have been unable to
track the reason for the error message. Any suggestions?

 

[Guest]

Hey Eds,
I had the same issue and resolved it by "un" - indexing my Memo Field.
Goodluck,
Braindead

 

[Guest]

Hey BrainDead,

After much searching for a solution, yours has to be nominated for "Top Tip
of the Day" in my book. Excellent advice, cheers.

Ian.