what if date-field is empty

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
 
D

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