Crosstab in a form

[Gismo]

Hi all,

Is it possible to have a crosstab query in a form?
When the crosstab query gets added coulombs as the data changes or added, such as months, how will this be automatically be added in the form as the form are set in the controls created

 

[theDBguy]

You can display a crosstab query as a query in a subform. Otherwise, you'll need some code if you want to use other controls.

 

[Gismo]

Hi all,

Any reason why the cross tab query on a form would display as below?

I have to click click on the + first to display the query

 

[June7]

I tried dragging a CROSSTAB query onto a form and Access does not allow this for any table/query. I have to first install subform container control and set its SourceObject property to CROSSTAB query. Was table/query drag and drop added to versions after Access 2010?

 

[Gismo]

I tried dragging a CROSSTAB query onto a form and Access does not allow this for any table/query. I have to first install subform container control and set its SourceObject property to CROSSTAB query. Was table/query drag and drop added to versions after Access 2010?

Yes I am using 2016

 

[Gismo]

When I drag on a crosstab, the wizard automatically creates a form.

Thank you
Did not know It would automatically create a form
I first created the form then dragged the query

But dragging the query onto the main form worked well