Main and Sub Reports using LinkMasterFields & Link ChildFields 1

[seca650]

I am building a report in access that will require a front page. This report will carry a document number and will be revised many times. I believe this is a good application for main and Sub reports. The main report will contain the front page and the detail of the data, the sub report will contain the revision information and will be shown in the middle of the front page. I am unable to establish the link between the two reports, with accurracy (I get all the records in my my subreport and not just the records specific to the corresponding main report). My main report is based on a query and my subreport is based on a table. I have established a relationship between one of the tables used in the main report query and the table used in the sub report. Any help in setting this up is greatly appreciated.

Ken

 

[mp9]

In the design view of your main report, right-click on the sub-report object and select Properties. In the resulting window, select the Data tab and ensure that your Link Child Fields and Link Master Fields properties are set.

To clarify, the Link Master Fields is the name of the control on the main form that you want to link to the field on your sub-report specified in Link Child Fields.

http://www22.brinkster.com/accessory/

 

[seca650]

mp9 thank you for the insight, I am back on track with my report. A little clarification goes a long distance.

Thanks again

Ken