Thanks gemma-the-husky. Actually it is not so much an error message but a message that states the field must be filled because it is a requied field as set up in the table.
As a temporary fix I am using :
[Code] Private Sub Form_BeforeUpdate(Cancel As Integer)
If Nz(txtIssueDate, vbNullString)...