I have a samall problem .When i enter a date value through a recordset object the sql statement does not execute.

i am getting this value from a textfield which is blank.
the idea is to enter date of birth which the user of the form may not know.so to allow null entries.
please help.
thanx