Good Morning - Thanks in advance for the help.
I'm a novice at VBA and need some help in what may be a simple question.
I have written some code that incorporates an event listener, which when triggered, spatially intersects the newly created point with a polygon layer. The attribution from this polygon layer is then used to populate a corresponding field in the point layer. The use of this tool generated interest from other users. They would now like to run this same process iteratively, collecting attribute values from a series (10+) of polygon layers whenever a new point (address point) is created.
I have expanded the tool to make this possible, however, it requires that the source (polygon) layers be within the map document. Is there a way to do this without having all of the source layers loaded in the map document? Can I call the data directly from the sql db?