That what I would like to do, but I'm a Newbee. The above code is a part of a module(with corresponding form) that returns a value for 30 recordsets. I have several modules(8) for different forms. Everything is mainly at a Parent level. It's at the subname level where all the scenarios come into play because I need the names(30) to change in the SQL statement based on the criteria. Ex: "If combo1.text = "LFDIV_AN" THEN " the names in SQL statements would change. Complex?