The Patch in question is halfway through. I've checked the contents of BRHoodList and EditsHoodList and they are fine. I've also run that exact patch with HoodList replaced with a copy of the table called RefHoodList. And I've put the patch as seen above Patch( HoodList...) on a button without any other code and it worked.
I think that the Patch is not able to complete because the tables used in the patch are cleared in the following lines of the above code.
If I'm right, how can I work around this and still reconcile my data all in one click?