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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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"
 
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().
 
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?
 
Its in the properties of the control under the "Others" tab...Checkbox The
default setting is No.
 
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.
 
Back
Top