Is that something like:
"As I was going up the stair,
I met a man who wasn't there..."?
I can't tell you what to do, necessarily... but I can tell you why there was
a not-visible Field on the Report, most likely.
Access Forms are "kinda dumb" in that they keep all the Fields in the
RecordSource available (actually, that's most likely because they were
intended to be interactive and the likelihood is higher that you may do
something that requires an additional Field), so you can use any Field in
the RecordSource as the LinkMasterFields or LinkChildFields property of the
Subform Control.
Access Reports are "kinda smart", in that they don't keep Fields available
unless they are used in the Report... so you can't use a Field that's just
in the RecordSource, but not used in the Report as the LinkMasterFields or
the LinkChildFields of the Subreport Control to synchronize the data.
Possibly there is some way that you can jump through hoops in VBA code to
eliminate the need for the invisible Field.
Because Reports, in Access 2007, have some interactive features, this may
not apply in Access 2007.
It's possible with knowledgeable use of Queries, to create a Report that
appears the same as one with a Subreport Control, but actually just uses the
Query to "flatten" the data, and the report ignores duplicated fields either
by "hide duplicates" or by using the Sorting and Grouping properties of the
Report. You could take a look at that approach.
Or, you could look at alternatives to exporting the Report to Word. I've
never been able to get an accurate preservation of the format I saw in
Access... and Heaven Forbid that I set Word to show all its markup control
characters. Of course, I haven't tried that for several versions, so it
could be a bit better now.
Larry Linson
Microsoft Office Access MVP
