what if date-field is empty

  • Thread starter Thread starter Jean-Paul
  • Start date Start date
J

Jean-Paul

tb!datum_uitvoer = Me!Datum_opdracht
Returns an error when me!Datum_opdracht is left empty

I tried tb!datum_uitvoer = Nz(Me!Datum_opdracht,"")

but this isn't correct...
What is?

Thanks
JP
 
Date fields must contain dates or Null.

If you don't want the date field to be Null, you'll have to pick a default
date to use:

tb!datum_uitvoer = Nz(Me!Datum_opdracht, #1900-01-01#)
 
Back
Top