Formulas in Page Header of unbound Main report result in "#Name" Error 1

[SMarkSch]

I have written my first set of reports (eight of them). Each based on their own query based off of the same table.

I have a master report which serves as main report which pulls in each of the eight subreports. I believe this main report to be unbound. The master/main report looks great except for three text boxes in the page header and footer which have formulas that result in "#Name" errors. The formulas are simple, in one case: '="Rev.: C" & [tblDATA_00]![G02] & " - R" & [tblDATA_00]![G04]' where [tblDATA_00] is one of my tables and [G02] and [G04] are text fields on that table.

Any help would be appreciated.

Note: I can hold my own when it comes to tables and queries but I am only a novice at when it come to reports and I have stayed away from the other areas of Access.

 

[dhookom]

If you want information from tblData in the main report then you should set the record source to tblData.

Duane
Hook'D on Access
MS Access MVP

 

[SMarkSch]

Thanks...I thought I had already tried that--and had in a way.

When I did I was still using the references of '[tblDATA_00]![G02]'. I have changed them to simply '[G02]'.

The tblDATA_00 is a multi-row table (which I am sure violates the concept of a relational database) so I changed it to a table that only contains one row.

Thanks once again.