Form based on crosstab query

R

Robbro

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?
 
D

Duane Hookom

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crosstab Query Input Failure 2
Controlling position of query window 1
Null to Zero in Crosstab Query 1
Crosstab query problem 4
Parameter question for crosstab queries 1
report based on crosstab query 8
Crosstab query in Report causes errors 4
report using a subreport based on a crosstab query 5

Top