Updating fields ??

[Dre313]

I have a form, which pulls records in to update ( modify, close ) My problem is when i pull in a record I can make modifications no problem.. It allows me to update.. all fields except for the close date field.. When I leave the close date field empty ( since that record isnt closed .. yet ) it gives me an error when i try to update w/o a date in there.. ( type mismatch) but if i put a date in there .. everything works fine..

Is there a way I can leave that field blank then update it w/o having to put a date in..

thanks

 

[zevw]

Is the property for that field required in the table, if so in the design view of the table sti to not required.