Using crosstab query in subform

[Chlaris]

Dear all,

In Access 2003, I can create subform with crosstab query as record source.
How to implement this in Access 97 ?
Thanks.

Chlaris

 

[James A. Fortune]

Dear all,

In Access 2003, I can create subform with crosstab query as record source.
How to implement this in Access 97 ?
Thanks.

Chlaris

I just created a subform in A97 with a crosstab query as its
RecordSource. Simple steps:

• Make sure the crosstab query runs.
• Put the name of the query in the RecordSource property of the subform
in Design mode.
• Drag any fields you want onto the subform before saving.
• After saving the subform, open it by itself to make sure the query
results show.
• Put the subform into a subform control on the main form.

James A. Fortune
(e-mail address removed)

 

[Chlaris]

Hello,

I have dynamic columns in subform.

I just created a subform in A97 with a crosstab query as its RecordSource.
Simple steps:

• Make sure the crosstab query runs.
• Put the name of the query in the RecordSource property of the subform in
Design mode.
• Drag any fields you want onto the subform before saving.
• After saving the subform, open it by itself to make sure the query
results show.
• Put the subform into a subform control on the main form.

James A. Fortune
(e-mail address removed)

 

[James A. Fortune]

Hello,

I have dynamic columns in subform.

What happens if you set the RecordSource property of the subform as follows:

Private Sub Form_Load()
lblColumn3.Caption = "5"
txtColumn3.ControlSource = "5"
Me.RecordSource = "qryX_Crosstab"
End Sub

Here txtColumn3 is a preexisting text box on the subform and "5" is the
name of a field from the crosstab query. You should be able to
determine in advance the field names that will be returned by the
crosstab query and set the Caption's and ControlSource's appropriately
before setting the RecordSource dynamically. Any textboxes and labels
that are not used can have their Visible property set to False.

James A. Fortune
(e-mail address removed)