Trapping Access Error 3200

[ChemistZ]

I have another post that is related to this one. In my claim form, if I change the key and then tab until I would normally go to the next record, I get error 3200. What I would like to do is trap it. So, I tried putting in the OnCurrent event this code

on Error Goto err_try
err_try:
if err.number=3200 then
msgbox "blah blah blah"
sendkeys "{esc}" to put form back the way it was
end if

However, I continue to get error 3200 instead of my message box. Have i tried the wrong event? I also tried before and after update and lostfocus. Help!!

 

[Nancy2]

It must be on the wrong event -- since the error trap looks OK.

1) What it is error 3200?
2) What control/field is causing it? I would tend to put it on the before or after update of the control - then undo and cancel the event - I guess before update....
3) You can also try using the On Error event of the form