VBA - Use data not loaded in ArcMap - Use data directly from source?

Discussion created by shaunrconway on Nov 19, 2010
Latest reply on Nov 19, 2010 by shaunrconway
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?