Can’t Set Value to NULL ??

F

FJquestioner

I have a subform in Single form view. every time I go to add a new record
I get 4 consecutive warning messages of “Can’t Set Value to NULL when
CheckBox property = Falseâ€. I have only 2 checkbox controls. One is set to
a calculated value. The other is locked with the default value left blank.
However, I tried setting the defaults to both -1 and 0 but I got the same
error message. Oddly, if I switch the subform into Datasheet view, the
problem disappears.

I suspect this is a basic set-up flaw but I'm not sure. Any assistance would
be greatly appreciated.

Thanks.
 
C

Candy

To solve this problem, check the property of each datetimepicker on that
form, chage the property field "check box" value to "Yes" instead of "No".
That might solve the problem.

Candy
 
F

FJquestioner

Yup, that did the trick. Thanks a lot.


Candy said:
To solve this problem, check the property of each datetimepicker on that
form, chage the property field "check box" value to "Yes" instead of "No".
That might solve the problem.

Candy
Click to expand...
 
Top