Hi all,
I have five edit boxes in a form which ex a code. I want to stop code if all edit boxes are Null but not if one or more is filled with data.
I tried the code below but with no success for obvious reasons- still not know how to proceed.
If IsNull(Me.a1) Or IsNull(Me.a2) Or IsNull(Me.a3) Or IsNull(Me.a4) Or IsNull(Me.a5) Then
MsgBox "Nothing to Print. " & Chr(10) & Chr(13) & "Please post Picking Numbers in 1,2... ", , pro
call cmdclearallnumbers_Click
Exit Sub
End If
...where a1 to a5 are the edit boxes
Can someone help please
Thanks in advance
Kenneth.
I have five edit boxes in a form which ex a code. I want to stop code if all edit boxes are Null but not if one or more is filled with data.
I tried the code below but with no success for obvious reasons- still not know how to proceed.
If IsNull(Me.a1) Or IsNull(Me.a2) Or IsNull(Me.a3) Or IsNull(Me.a4) Or IsNull(Me.a5) Then
MsgBox "Nothing to Print. " & Chr(10) & Chr(13) & "Please post Picking Numbers in 1,2... ", , pro
call cmdclearallnumbers_Click
Exit Sub
End If
...where a1 to a5 are the edit boxes
Can someone help please
Thanks in advance
Kenneth.