What could be the cause of "Invalid use of null" while trying to update a field?

[Sana Firdaus]

What could be the cause of "Invalid use of null" while trying to update a field?

[andy49]

It's difficult to say without more info. Are you on a form? Using a formula? Using SQL? and if so what is being done?

[NTC]

Look at the field property in the table in design view. If the field is the key field it cannot be null - or - if any field has its property of "Required" set to Yes.

[Sana Firdaus]

yes the field property is neither set as primary key nor it has the field property of required data but still while updating this field from the data taken from a different table,it shows invalid use of null!!

[John_G]

If you are using VBA, you will get this error if you attempt to assign a Null to a variable that has not been declared as type Variant.

[NTC]

that error message applies to the record - and can be attributed to any field in the record - so you need to check all fields.... if still hard to find - be sure to test by putting in a test value into each field 1 by 1 until you isolate