Prev: Graphs and charts in Access 2007
Next: Vista SP2 I can't install
From: Robbro on 12 Apr 2010 15:31
I had set up a form and am having trouble getting information from a crosstab
query into it. In the expression builder I can go to the query I want and
pull any info except for the crosstab portion. I tried setting the forms
recordsource property to the crosstab query then everything I had done
disappeared. Deleting that brings it all back. I'm obviously clueless
here....
How can I successfully import crosstab query info into a form control as
information?


From: Duane Hookom on 12 Apr 2010 23:50
Did you set the Column Headings Property of the crosstab?
I'm not sure what you meant by "crosstab portion".
You add a subform control onto a main form and then in the On Open of the
main form set the Source Object of the subform control with code like:
Me.subformControlName.SourceObject = "Query.qxtbMyCrosstabName"

--
Duane Hookom
MS Access MVP


"Robbro" <Robbro(a)discussions.microsoft.com> wrote in message
news:941427D0-4D51-47C1-8334-5C178372C454(a)microsoft.com...
> I had set up a form and am having trouble getting information from a
> crosstab
> query into it. In the expression builder I can go to the query I want and
> pull any info except for the crosstab portion. I tried setting the forms
> recordsource property to the crosstab query then everything I had done
> disappeared. Deleting that brings it all back. I'm obviously clueless
> here....
> How can I successfully import crosstab query info into a form control as
> information?
>
>
 | 
Pages: 1
Prev: Graphs and charts in Access 2007
Next: Vista SP2 I can't install