VB code to ignore error

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Add some error handling?

On Error Goto errhandles

Select Case err.number
case 3709
resume next
end select

HTH

EdS said:
Can someone help me with the code to ignore an error? The problem is: when
Click to expand...
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
Click to expand...
error, until I solve the problem. Any help?
 
Back
Top