Recent content by BenFranske

Thanks! That got me started on the right track. I thought it might be something to do with recordsets but I'm not especially familiar with them and needed a little extra guidance. As an aside, is there a compelling reason to use ADO instead of DAO? I had a problem with an unknown type when...

Hi, I have the need to create the equivalent of a WHILE EXISTS SQL loop in Access and am thinking there should be a way to do this with some VBA code. Some background: I'm working on a family tree database so each record (back to the root) has a parent record in the same table creating a...