Hi there, I'm working on database with MS SQL Server as back end. I have a form based on table with restriction for 'not blank' in some fields on back end side, and there's a problem when editing or adding a new record. If a field is blank I can easily tab through the form, same as if it's not blank. However, after deleting content I cannot skip to another field before putting anything back to it, and there's an error popping out:
'You tried to assign the NULL value to a variable that is not a Variant data type'
I have BEFORE UPDATE macro that checks all the fields for this very purpose, but this error happens way before I even attempt to save the record.
I played with if statement found in this post.I tried to put it through macro editor as well as VBA editor, placing it on both form and particular field properties (on dirty, on change, before update, on lost focus) unfortunately with no luck.
Does anyone know how to get rid of this error please?