subreport

[gal]

hi guys,
I have a report and a subreport with Name and ID fields.
In the first case my subreport has a Child field ID with
the same ID in themain report and everything works fine.
When I create another subreport and link the Child field
Name to the Name field in the main report I get a blank
report. Is there a conflict between text fields in
relation Main report-Subreport or there is something else..
Just for clarification I am able to run Report based on
Name exactly the way I want it. The problem begins when I
try to include that very same Report as Subreport to a
Main report.
Help is needed
Thank you

 

[Allen Browne]

Reports (like most other things in Access) have a Name property.

If you have a field named Name, Access will probably confuse the name of the
report with the field called Name. Since none of the subreport records match
the name of the report, no records are returned. The same thing happens if
you use fields named Date, Section, etc.

In table design, change the name of the Name field. Save.
Open the report in design view.
Right-click the subreport control, and choose Properties.
On the Data tab, set the LinkMasterFields to the new field name.

Just to confuse things even further, Access may try to remember the old
field name and get confused again trying to sort that one out. To prevent
that, uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
before you rename your field, and then compact the database just to be sure:
Tools | Database Utilities | Compact
If you want to know more about the problems with NameAutoCorrect, see:
http://allenbrowne.com/bug-03.html

 

[gal]

Thank you Allen
You are genious. Sorry couldn't get back to you
earlier,but I had a lot of things to do. But you have
solved my problem, Thank you
gal