Receiving the following Error 'The Search Key was not found in any record' What is causing the error?
Posted on 2006-10-30
There is probably a simple solution, but this has happened three times now, corrupts the record that is active, then I receive the error when I try to edit or delete the record. (Lots of Squares pasted in the record).
After doing a Compact/Repair I can delete the record, but the data is lost.
Basically, the error occurs when the Users runs an SQL string in VBA that updates specific / open records. The user has made a change to the current record, but the record is not updated (As it is still the active record), then the User click on the update button.
Any suggestion on correcting the code or trapping the error and preventing the update?