error...can't set value to null...

[Guest]

I am trying to create a data entry form. It contains an auto number for the
record ID. a microsoft time date picker for the date, several option boxes
for the data. The option boxes have from two to 7 choices. The underlying
form uses auto number, Date, and everything else is number (long integer)
When i go to a new record, I get an error code that says, "can't set value to
NULL when checkbox property = FALSE"
I am not using any check boxes and I cannot find any reference to "check box
property"

 

[Guest]

Dennis,

This is because you have a Null value in the DTPicker control. If the
control source is the date field of your table put a default value in the
table date field such as Date().

 

[Guest]

That worked! I never would have thought to look there since the error said
the check box property was set to false. Where did that come from?

 

[Guest]

Its in the properties of the control under the "Others" tab...Checkbox The
default setting is No.

 

[Guest]

I'm having the same problem and trying to use the same solution BUT: the way
you suggested, I can never have an empty date field when creating new records
because there is a value by default and the calendar doesn't allow me to
delete it.

The question is: how can I use your solution and also allow empty date
fields ?

Thanks.