Empty Field

  • Thread starter Thread starter depawl
  • Start date Start date
D

depawl

How would one go about resolving this issue:
I have a form with a list of report dates. If a certain date field is
empty (user hasn't entered any data), I would like the previous date to
appear in a "next date due" field. I can't figure out how to code the
empty field. In the after update event of a combo box where the user
selects a certain employee, I have:
If Me.reportdate2.Value = [empty field] Then
Me.NextDate.Value = Me.ReportDate1.Value
End If

The [empty field] part is what I can't seem to get.
Thanks.
 
If txtDate is the name of a textbox control in the form, and that textbox is
bound to a Date field report_date in the underlying database table:

if isnull (me![txtDate]) then
' there is no value in the report_date field.
else
' there IS a value in the report_date field.
endif

HTH,
TC
 
Back
Top