I am trying to update a record and I am receiving the message "The search 

key was not found in any record."  It is only one field that is giving 

this problem and the field only gives the problem in that specific 

record.  The field is a foreign key to a look up table and the number is 

one of the IDs in the look up table.  I am using Access XP.  I looked in 

the help files and found the below explanation.



The search key was not found in any record. (Error 3709)

This error occurs when an ISAM SEEK is being executed and there are no 

matching values in the index.



I am not sure I understand this explanation.  Moreover, this is not the 

first time data has been updated in this table and there are many copies 

of this database being used by my client that have never gotten this 

error.  Why is this cropping up?  Does anyone have any idea what is 

causing it?



Thanks,

Yehuda

You may have an "unprintable" character within the data field you are

searching. Does a partial search return the same error?



Walt