MS Access Database Error

I keep receiving the following error when a macro runs. It completes the task and then when I close the form an error saying: “You can’t assign a value to this object”
I tried to resolve the error by recreating the fields and checking the settingsand everything is correct. Ran a compact and repair and still receive the message even though its completing the task. Any ideas?