>Well, you understand that it's the changing structure that's the problem.
>
>I've worked around this with a view off a "unuversal" structure containing all the fields I'll ever need. Make this your recordsource. Then, in pseudo code:
>
> 1. Make your query to a table
> 2. Select the universal structure, zap
> 3. Append from the table
> 4. Refresh the grid.
>
>I'm sure there are other ways this can be done but this one's worked for me.

Interesting concept, a universal view structure. I'll have the try it. And yes I do understand the nature of the problem, but I still don't think that the underlying definition should get wiped. My custom textboxes should still be there regardless and not swapped out for Text1.

Thanks,
Steve