T
Tony Williams
I have a control on a form that I want to ensure the user completes before
moving on. It is a date control and I'm using this code in the BeforeUpdate
of the control
Private Sub txtMontha_BeforeUpdate(Cancel As Integer)
If IsNull(txtMontha) Then
MsgBox "You can not enter a record without completing the Qtr End Date,
vbCritical, Need Qtr End Date"
End If
End Sub
How ever nothing happens, can anyone tell me why. I've tried enclosing the
dates in "#" but the debugger doesn't like that.
Can IsNull be used for date controls?
TIA
Tony
moving on. It is a date control and I'm using this code in the BeforeUpdate
of the control
Private Sub txtMontha_BeforeUpdate(Cancel As Integer)
If IsNull(txtMontha) Then
MsgBox "You can not enter a record without completing the Qtr End Date,
vbCritical, Need Qtr End Date"
End If
End Sub
How ever nothing happens, can anyone tell me why. I've tried enclosing the
dates in "#" but the debugger doesn't like that.
Can IsNull be used for date controls?
TIA
Tony