Hello all,
I cannot get a simple check to work the way I want it to. I want to ceck to see if a value has been entered in WOQty, and if not I want a MsgBox to open and set focus back to WOQty field but I can't seem to get it to work properly. When I go into debug it says WOQty = null but I don't get the message box and the cursor doesn't go to WOQty field. I am not feeling well today and I know I am not thinking straight but this is beating me up.
Private Sub WOSchedDate_AfterUpdate()
DoCmd.RunCommand acCmdSaveRecord
If Me.WOQty = Null Or Len(Me.WOQty = 0) Then
MsgBox "You MUST enter a Qty for the Work Order.", vbOKOnly
Me.WOQty.SetFocus
End If
Me.CmdAllocate.Visible = True
End Sub
Thanks
Dave