How to refer report's recordset ?

  • Thread starter Thread starter Malee
  • Start date Start date
M

Malee

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 said:
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.
Click to expand...


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)
 
Back
Top