I have an unbound form from which data entered by user is saved to various
tables when user clicks on 'save' command buttons. Among the fields are
several date fields that do not have to be entered in all circumstances. I
use an SQL statement & docmd.runsql but if date field remains null, I get an
error about a field not being saved. I tried Nz function but I don't think
this works with dates. Any suggestions on how to avoid error would be
gratefully accepted. Thanks.

hi chris

1. do check the design of table and see whether the option required of
the date field is set to no.

2. check if the date is selected by the user using len function is
isempty etc.., if date is been selected pass along the datevalue in
the sql statement or else pass a NULL.

hope this helps.

thanx, peace, have a great day

regards
bala