Why am I getting "Label Not Defined"???
I've been staring at this for an hour!!! help please
Private Sub LNEW_Click()
On Error GoTo Err_LNEW_Click
Dim intaswer As VbMsgBoxResult
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
intaswer = MsgBox("DO YOU WANT TO OPEN A NEW TICKET?", vbYesNo + vbQuestion, "NEW TICKET"
If intaswer = vbYes Then
Forms!MAIN!FRM_SUB.SourceObject = "FRM_TICKETS"
Forms!MAIN!FRM_SUB!Combo15.SetFocus
Forms!MAIN!FRM_SUB.Requery
Forms!MAIN!FRM_SUB!Combo15.SetFocus
Else
If intaswer = vbNo Then
DoCmd.CancelEvent
End If
End If
exit_LNEW_Click:
End Sub
Err_LNEW_Click:
MsgBox Err.Description
Resume exit_LNEW_Click
End Sub
I've been staring at this for an hour!!! help please
Private Sub LNEW_Click()
On Error GoTo Err_LNEW_Click
Dim intaswer As VbMsgBoxResult
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
intaswer = MsgBox("DO YOU WANT TO OPEN A NEW TICKET?", vbYesNo + vbQuestion, "NEW TICKET"
If intaswer = vbYes Then
Forms!MAIN!FRM_SUB.SourceObject = "FRM_TICKETS"
Forms!MAIN!FRM_SUB!Combo15.SetFocus
Forms!MAIN!FRM_SUB.Requery
Forms!MAIN!FRM_SUB!Combo15.SetFocus
Else
If intaswer = vbNo Then
DoCmd.CancelEvent
End If
End If
exit_LNEW_Click:
End Sub
Err_LNEW_Click:
MsgBox Err.Description
Resume exit_LNEW_Click
End Sub