Hi everyone,

I am having trouble with the check boxes in my subform. The subform is base on the query of a tbl in open form event with the check box is being true. The subform populated fine. But when the complete check box is unchecked (changing the underlying records) the Record remains on form and displays #Deleted across the record. Pencil icon displays as well. Then when I clicked on the another record the error below appears then record gets removed. How do I get the record remove immediately from the form when I uncheck the complete box?
I tried Me.requery, me.refresh, rst.update. They don't work.
Could someone provide some help or explanations.
Thanks for any assistance.

Run-time error 30014:

You canít update the record because another user or application deleted it or changed the value of its primary key.