Message box if one of two fields are blank
Posted on 2014-02-15
I'm trying to make a message box appear if either of two fields on a form are blank. If either one of then has data entered then the message box does not need to appear. Here is my code. But it's not working when both fields are left blank.
If Nz(Me.txtIncomingQty, "") = "" Or Nz(Me.txtSoldQty, "") = "" Then
MsgBox "You must enter both an incoming and a sold qty."