Hi,

I am getting type mismatch error. The txtDONO (Delivery Number) property set to text. Using MS Access database and the following is the code:

VB Code:
  1. Private Sub txtDONO_Lostfocus()
  2. If txtDONO <> 0 Then
  3. txtSNO.SetFocus
  4.  
  5. Else
  6.  
  7. Dim MB As String
  8. MB = MsgBox("First enter the Delvery Number", vbYes, "Enter D.O. Number")
  9.  
  10. If MB = vbYes Then
  11. txtDONO.SetFocus
  12. End If
  13. End If
  14. End Sub

Margaret