I'm a little confused by this...this works perfectly fine in SQL Server if you set a field to allow NULL values, there is no error on Update, but even thought I have the same settings for Access, I try to update the RS and it throws an error saying I'm trying to update NULL values...



There has to be a way to do this, what am I doing wrong?

UPDATE:

I found the issue...one of the columns had required as Yes