Using Column reference as a report control

[jaaret]

I successfully pull data into a report from a column in a form's combo box, for example:

Control Source =cmbContactID.Column(3)

Is it possible to use this method to pull in data from a column in a query rather than use the field name?

The reason I ask is this:
I've built a crosstab query to abstract projects by month on a rolling 120 day cycle. The rows list the projects, the columns list the months and the value displayed is the due date. Since the names of the columns change from month to month in the crosstab I've been going in and manually changing the control source for the report fields each month. It seems like referencing the query column should resolve this.

Is this the best way to approach building a report on a crosstab query that changes over time?

Thanks in advance,
Jaaret

 

[Remou]

Have a look at this:

faq703-5466


You can refer to fields in a number of ways, but I think the above will suit better.