I have a form linked to a Table.
In the form, I have some textboxes, some checkboxes, and a AddRecord
command button.
I set the validation rule of the txtEmpNo textbox to Is Not Null, I
set the validation text to 'required field'. I entered in the
AddRecord.Mousedown section:
If Me.txtEmpNo.text = "" Then
MsgBox("Required Field")
Me.txtEmpNo.SetFocus
End If
No error message pops up and the record still gets entered in the
Table. How do I get an error message to pop up and not insert the
record.
signed A confused beginner programmer