How to Use Recursive VBA Functions in MS Access

28-September-2021
Tree mapping can really be a chore when you’re trying to find out where a particular member resides. Whether it is a family tree, or a manufacturing parts tree on a bill-of-materials, navigating and reporting on trees can be a hassle. One solution is to use loops to build trees from the top-down, assigning part maps along the way, but this is generally a hassle. Enter the recursive function in VBA. Recursion is a simple and elegant way to create functions that call themselves to create mappings. This is particularly true for self-joined tables with unlimited hierarchies stored in them. In this episode, we’ll use a recursive VBA function to generate a person’s mapping, either through the father’s, or mother’s side. Join me as we do some mapping through the use of recursion!



MS Access Project? Contact me today!