I'm trying to trap error 2237 in a combo box, when a user enters an item that isn't in the list. The following is the After_Update code that powers the combo box.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[PersonID] = " & Me![cmbName]
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
cmbCRN.Value = ""
cmbPostcode.Value = ""
I've tried to trap 2237 in the Before_update and Change events but I still get the generic Access message. Where should the error handler go?