I need to have the update stopped if the user has not completed the date when trying to update the country field I get the attached error message. So, how do I stop in the before update event data entry and move the focus to another field?
Private Sub cboCountry_BeforeUpdate(Cancel As Integer)
If IsNull(Me.txtDate) Or Me.txtDate = "" Then
MsgBox "Please enter open date first prior to " & vbCrLf & _
"selecting a country. Temp Number assignment " & vbCrLf & _
"requires this data entry sequence.", vbOKOnly
Me.cboCountry.Value = ""