How do I add a field to report header

[jscriptor09]

Hi folks



I have an ACCESS 2010 Application by which I generate:

1. A table based on a query selection. The table name is fixed, but depending on selected query parameters, that content of the table changes.
2. A Pivot chart Form that is fed data from the table. Therefore, if the table shows info for the ASIA region, the pivot chart will be related to the Asian region. If the table contains info related to the European region, then the pivot chat will be related to the European Region ... and so forth.
3. A report that bsically contains the Pivot Chart

The problem:
On of the fields in the table contains which region the report is related to. Therefore, I am trying to add a header to the report that looks like this:
Sales Report For the & Table.Field1 & something ... something

The idea is to drop the field content where I have "Table.Field1 "

Again, this is the header section of the report. The mainbody contains the pivot chart displayed. The pivot chart has no title because I could not figure out how to add title using VBA on the fly. If this is an option and there is a way to do it, please advise.

Many thanks for your help.

Mike

[NTC]

one can call a table's field value, presuming you define the row. to take this route research DLookUp in VBA.

or you could consider a subreport inserted into the header.

but a common and easy method generally involves the fact the report name is often found in the form the user is working with that contains the 'open report' button.....so referring to the text field in that form might be a solution:
=Forms!YourFormName.TheControlName

hope it helps.

[jscriptor09]

Hi NTC

I followed the last option. Thank you so much for the help

[jscriptor09]

How do I mark this solved?