I'm puzzled here. I had an extensive discussion with the OP about how his problem was that he used different queries which produced different field names, and so he couldn't use field field names. And so I provided him with a solution that allowed him to use a single form, but with different resultant field names.

However, you say here that you simply change the underlying query's SQL and use it in the subform -- which is fine, if the field names don't change. But otherwise you have to change the text boxes' control source properties.

So maybe I'm just missing something here (wouldn't be the first time). But how do you use different SQL statements with a single subform if the resultant field names may be different each time without changing the Control Source properties?

Thanks!