Column shown dynamically in datasheet form or List box as per the availability of data in crosstab query

[ahmad_rmh]

I want to make datasheet form or List box but the columns should have to be shown in datasheet form or List box dynamically as per the availability of data in cross tab query.


suggest please.

 

[CJ_London]

Easiest way is to have a subform control on a form and set its source object to

query.mycrosstabqueryname

 

[ahmad_rmh]

Easiest way is to have a subform control on a form and set its source object to

query.mycrosstabqueryname

Doing in the same way but as the new data columns added in cross tab query the sub form just showing the old columns and not adding the new columns.

 

[arnelgp]

can you set the SourceObject of the subform to the query.yourQueryName?

//already in post#2

 

[CJ_London]

the sub form just showing the old columns and not adding the new columns

In that case you are not doing what was suggested

 

[ahmad_rmh]

Easiest way is to have a subform control on a form and set its source object to

query.mycrosstabqueryname

thanks CJ, & Arnel, Done & Solved,

Now I want to implement the same way in report.

How to implement?

 

[arnelgp]

How to implement?

the same way as in Form, you add a SubForm and on the Open Event of the Report, set the SourceObject of the SubForm.

 

[ahmad_rmh]

the same way as in Form, you add a SubForm and on the Open Event of the Report, set the SourceObject of the SubForm.

It just show datasheet form in report view, I want to show as a report view.

 

[CJ_London]

Big subject - see this link for what’s involved

access report from dynamic crosstab query and vba to "manually" generate reports

I have come across the problem of generating complex access reports (by complex I mean with data processing, variable number of fields, among others). Let me explain in deeper detail some of the th...

stackoverflow.com