Dynamic Text Boxes need on Form

[mattc66 via AccessMonster.com]

I have a form that I need the txtBox header to change based on the underlined
data source.

My data source is a cross tab query. The column heading is a due date.

Table Data

Item Qty DueDate
Widget1 10 8/20/2006
Widget1 10 8/31/2006
Widget1 15 9/1/2006
Widget2 30 8/20/2006
Widget2 20 8/31/2006


I need to display this in a cross tab query on a form.

The issue is when the data changes in the underlined table, the cross tab
query is updated, but the Form headers remain as they were when I created it
originally. So as an example, if the due date changes on Widget1 for 10 on
8/20/2006 and is now due 8/22/2006 and the table data is updated. The cross
tab query if viewed reflects this new column. However my form only shows the
Widget2 for 30 on 8/20/2006 and the 10 now due on 8/22/2006 is hidden, unless
I recreate the form and add a fld called 8/22/2006.

I need the flds to be dynamic on the form to reflect these types changes.
Does anyone have a suggestion on how I could do this. I do need the column
header to show the Due Date.

Thanks
Matt

 

[Duane Hookom]

There is a sample of how to create a dynamic subform at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.