VBA Error Handling

[jimmyac23]

Hi, is there a way to turn off a specific error? The error in access is error #2105. I am telling my user to select a value if they did not already, and then setfocus back on the textbox, but I get an error message after I display the message box that "You can't go to the specified record" and would like to turn this message off. Thanks!

Option Compare Database

Private Sub ContactType_AfterUpdate()
    ContactPosition.Requery
    ContactPosition.Value = ""
    Me.ContactType.SetFocus
End Sub

    Private Sub Region_AfterUpdate()
    Borough.Requery
    Borough.Value = ""
    Neighborhood.Value = ""
    End Sub

Private Sub Borough_AfterUpdate()
Neighborhood.Requery
Neighborhood.Value = ""
End Sub

Private Sub Form_BeforeUpdate(Cancel As Integer)

    'Contact Position
    If IsNull(Me.ContactPosition.Value) Or Me.ContactPosition.Value = "" Then
        MsgBox ("Please select a contact position.")
        Cancel = True
        Me.ContactPosition.SetFocus
    End If End Sub

[pbaldy]

Here are the basics:

http://www.baldyweb.com/ErrorTrap.htm

[jimmyac23]

Thanks! I tried adding in error handling into my code, but still was unsuccessful. I've been searching for a solution like this for many days now but am still very confused. Any help would be appreciated.

Private Sub Form_BeforeUpdate(Cancel As Integer)    On Error GoTo ErrorHandler
    
    'Contact Position
    If IsNull(Me.ContactPosition.Value) Or Me.ContactPosition.Value = "" Then
        MsgBox ("Please select a contact position.")
        Cancel = True
        Me.ContactPosition.SetFocus
    End If
    
MyExit:
    Exit Sub


ErrorHandler:
    If Err.Number = 2105 Then Resume MyExit
        
    
End Sub

[pbaldy]

The error may be coming from the form's error event rather than the before update event.