How to refer report's recordset ?

I create a crosstab query and use it as my report recordsource. Because I
can not predict which column (return from query) will be exist, So I think I
will create enough unbound text boxes in report to display return columns.
Afer try, I found problem that I can not refer to those columns in term
Me.Recordset!ExpectedColumnName within Detail_Print event. Actually
Recordset is not available. How to solve this problem ?

TIA
Malee

There are several examples of crosstab reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. If your columns are
date intervals then there is a much easier method.

--
Duane Hookom
MS Access MVP
--

"Malee" wrote in message
...
I create a crosstab query and use it as my report recordsource. Because I
can not predict which column (return from query) will be exist, So I think
I
will create enough unbound text boxes in report to display return columns.
Afer try, I found problem that I can not refer to those columns in term
Me.Recordset!ExpectedColumnName within Detail_Print event. Actually
Recordset is not available. How to solve this problem ?

TIA
Malee

Malee wrote:

I create a crosstab query and use it as my report recordsource. Because I
can not predict which column (return from query) will be exist, So I think I
will create enough unbound text boxes in report to display return columns.
Afer try, I found problem that I can not refer to those columns in term
Me.Recordset!ExpectedColumnName within Detail_Print event. Actually
Recordset is not available.


In the versions before the Recordset property was
introduced, I used the ugly and sometimes slow technique of
opening a recordset on the recordsource, which won't work
with some types of filtering:

Set rs = db.OpenRecordset(Me.RecordSource)

--
Marsh
MVP [MS Access]