I used "Is Null" and i tried to update to "New" and it said, "you are about to update 3641 records ect...." When I clicked "yes" I get MS Access didnt update 3641 fields due to type conversion failure, due to key violations, due to lock violations, due to validation rule violations......Then asks, "Do you want to continue?" I click yes and nothing updates.

---

Reply from Alex Hedley:

Which Field are you trying to Update?
What is the Type of the Field?
Have you set up any validation rules on it?