programmatically setting ControlSource for crosstab DAP columns

Problem: The Textbox ControlSources (and Label InnerText Column headings) 
bombs for data access pages (DAPs) based a crosstab query when the
underlying 
the dataset changes when we roll into a new month.

Description:  I’m creating DAPs derived from crosstabs based on a
rolling 
12-month dataset.  My problem is that as we roll into a new calendar
month, 
the 12-month window changes but my stored crosstab query’s headings
change.  
The DAP wants to keep the column heading for the month that is no longer
in 
the 12-month window and the textbox wants to keep the outdated
ControlSource.

The ControlSource property doesn't seem to sup****t functions, which could 
programmatically point to the data source.

A full explanation of my efforts to solve the problem, including code 
snippets and screenshots, is available at:

http://www.christianbahnsen.com/experiments/xtab_column_heading_problem.mht

I apologize for posting the page outside the newsgroup, but I don't see a 
way to include graphics in this posting.

I have a feeling that the solution, if there is one, lies in the 
AlternateDataSource property, but information about the ElementExtension 
object is sketchy at best.


 

-- 
Christian Bahnsen