VB code to ignore error

[Guest]

Can someone help me with the code to ignore an error? The problem is: 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. I have researched (as suggested) Microsoft's knowledge base, which referred to excess info into a memo field, but that is not the problem.

For the time being, I would like to add code that would just ignore this error, until I solve the problem. Any help?

 

[Newbie]

Add some error handling?

On Error Goto errhandles

Select Case err.number
case 3709
resume next
end select

HTH

Can someone help me with the code to ignore an error? The problem is: 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. I have researched (as suggested) Microsoft's
knowledge base, which referred to excess info into a memo field, but that is
not the problem.

For the time being, I would like to add code that would just ignore this

error, until I solve the problem. Any help?