what if date-field is empty

[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

 

[Douglas J. Steele]

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#)