Subform with dynamic number of columns

[modbass]

i have a Form that uses VB to push a recordset to a subform and this works great.

but now i have a Pivot query that uses seasons and each season could have a different number of dates (the sunday of each week) so my query works fine pulls back my data and pivots it and puts the dates as columns like i want.

but i cannot figure out how to push this to a subform is i do not have the subform start with a query it does not update.

i can see the subform flash when i push my search button (using onclick) but it does not populate the subform with any thing.

input?

Thanks

[Guus2005]

Can you post a sample database?