Sub Reports

[Alisa]

Strange. I would look at the source object on the subreport, and make sure it matches the subreport that you edited. If all else fails, I would delete the subreport off the main report and then add it back on.

 

[aben77]

do you know what code i could put into a text box (??) that would print the table name in the page header? i think that might solve my problem.... =table ?? =tablename ??? thx

 

[Alisa]

do you know what code i could put into a text box (??) that would print the table name in the page header? i think that might solve my problem.... =table ?? =tablename ??? thx

Well, the first question is, how do you know which table name you want to appear?

 

[aben77]

i obviously have a very funky database design which is creating lots o' problems. i've deduced that neither the page header nor page footers from my subreports are appearing on the main report. as such, i thought i could solve my problem by putting the table name at the page header of the main report. so the table name i want at the top is the one corresponding to the subreport being printed on that page...

secondarily, i'm trying to actually import all my data from my 20 tables into one master table in a new access project... this may be ultimately the cleanest way to go....

 

[Alisa]

i obviously have a very funky database design which is creating lots o' problems. i've deduced that neither the page header nor page footers from my subreports are appearing on the main report. as such, i thought i could solve my problem by putting the table name at the page header of the main report. so the table name i want at the top is the one corresponding to the subreport being printed on that page...

secondarily, i'm trying to actually import all my data from my 20 tables into one master table in a new access project... this may be ultimately the cleanest way to go....

When you add a subreport to a report, it usually labels it automatically for you . . . If you already deleted the label, you can just add another one and make it say whatever you want.

 

[aben77]

the name of my subreports is not showing up anywhere on the main report when it prints out (on screen or on paper)... so i was trying to force it to do that by manually entering text boxes into each subreport page header. but those are not displaying in the main report. so i then figured the only way to make the text box display the changing names of the subreports was by somehow inserting a "field"... but alas maybe all this is too cumbersome...

 

[Alisa]

Just add a label. You can make the label say whatever you want. Headers on the subreport won't show on the main report, you have to put the label on the main report.