I'm attaching a zip. It contains a database that is a revision of the last one you posted.
I created a Form called Form1 --Purpose: To assign Customers as FacilityMgr or Room POC. For me, and I do not know the details of your set up, it is a form that allows the user to:
-Select a Customer from a combo of Customers
-Select a Building from a combo of Buildings
-offers an Option Group to identify
a) if this is to be a FacilityMgr, or
b) if this is to be a Room POC
It does not change anything at this time. It simply goes through a process and displays Message of what I think should be done. This is an iterative way to determine what the proper logic should be.
Open the database --separate from anything you are doing.
Open Form1 and try it.
Comments are welcome, as are it should do x, y, ...z