I have a crosstab query that is generated in VB. The query serves as the record source for a subform that displays a datasheet. The query generates a column called Category and then a bunch of columns for each fiscal year. This is fine for now, but as the next fiscal year starts to appear in the underlying data, the crosstab query will create an additional column that will not be known to the subform.



How do I programmatically create a field on the subform and link it to a new column when one appears in the crosstab? Is there an easier way to do this? Am I over thinking it?

I am new to Access and these forums, so thanks!

Kman