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 in each 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'm stumped. Any idea as to what may be causing this?
 
K

kiwibirdsong

Have you tried setting it to -1. I have found this has worked for me in the
past.

Kiwi
 
K

kiwibirdsong

Silly me.. You did say you had used -1. Hope someone else can help.

My appologies
Kiwi
 
Top