Child form update based on crosstab query

Hello Access devs,

I have a subform bound to a crosstab query displaying various columns at run time.

Initially, when the form is run, only the rowheadings in the crosstab display, however, the column headings do not (there is s no column data when first run).

I need the column headings to display after the query is run. Is this possible and how can it be done?

Note that I've created a query from the cross tab and bound that to a form, but it still doesn't seem to refresh the columns.

Any help appreciated.

Thanks

As a side note to the above question, I created this rather dirty little solution:

Please Login or Register  to view this content.

It works by replacing the existing sourceobject. If anybody has a cleaner solution, plz advise.

Cheeers