wazz
Super Moderator
- Local time
- Tomorrow, 05:57
- Joined
- Jun 29, 2004
- Messages
- 1,711
hi. i'm trying to create my own error message and me.undo for err 3022 and can't get it going. i found a couple of threads from 2001 and 2002 that should have worked but aren't doing it for me. has something changed since then? i've tried putting the code with the control, the subform, the main form, in the main body of the code, in the error trapping, the beforeupdate event and on error event. the code should be simple right?:
does it matter that there is nothing in the main body of the code? any help and/or code would be much appreciated. - w.
Code:
ErrorHandler:
If Err.Number = 3022 Then
MsgBox "Duplicate..."
Else
MsgBox "Error Number: " & Err.Number & vbCrLf & _
etc.
End If