Hello,

I'm trying to display a datasheet view of the result of a crosstab query in
a subform. I can link the subform to the main form with a valid, common
field but only if I manually enter the column names in the query's column
name property.

I think what I'd like to do is write the query on the fly but because I
can't "see" the recordsource of the datasheet I suppose I need to update the
sql property of the querydef. Can someone tell me how to do that or perhaps
suggest a better approach all together?

Many thanks,

Mike