Using crosstab query in subform

  • Thread starter Thread starter Chlaris
  • Start date Start date
C

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
 
Chlaris said:
Dear all,

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

Chlaris
Click to expand...

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 said:
Hello,

I have dynamic columns in subform.
Click to expand...

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)
 

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

Text box contains #Error regarding sum value 4
Selection query with MAX(textfield) return null value if the matching record more than 2501 records 6
Create table from a crosstab query 2
Is it possible to get Access to ignore not recognizing a field nameusing some sort of error handling 1
Where to buy Access 2003 Developer 1
Error: Can't be started. Was unable to initialize the Windows Registry 1
MDE created by Access 2003 can't be opened with Access XP 12
Form based on crosstab query 1

Back
Top