can't set value to NULL error message?

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

Guest

Dear Experts,

Thank you in advance for helping people out. This site is incredible.

I have a form for entry of Products, and one of the fields [Discontinued] is
a Yes/No checkbox in the underlying table and form. I have the default value
set to No.

Out of nowhere after some sample data was entered, when I want to browse
through records, I get an error message:

Can't set value to NULL when checkbox property=False

Thanks again,
You rock!
Ivan.
 
Ivan,

Hard to tell with so little information. Look at your table to see if there
are any values other than 0 or -1 in [Discontinued]. If not, then some data
got put in without using the form. If that is not the problem, check to see
if any other control on the form is either getting data or puttting data from
another control. Also, see if any of your controls contain NULL, and look at
the field properties for the control source for the control and see if nulls
are allowed.

Hope this will help
 
Back
Top