I have a problem with a subform which is based on a crosstab query. The crosstab query has a parameter which uses the value in a textbox on the main form.
The subform is hidden when the main form opens and the SourceObject property of the subform is blank.
There is a command button on the main form & when it is clicked the SourceObject property of the subform is set and the subform is made visible. However, when the button is clicked the subform only shows as a blank. The subform shows correctly if I open it on its own, as does the crosstab query on which it is based.
If I set the SourceObject property for the subform in design view I get the following message when the main form opens :
"You can't use a pass-through query or a non-fixed column crosstab query as a record source for a subform or subreport."
I tried setting ColumnHeadings property of the crosstab query and saving it - as recommended in other posts - but then I get the following message when I try to pen the query:
"This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements."
Can anybody help to find a way around this please
Usual thanks for the expert help