How is data from filtered records (from a given table) linked to the report form (or subreports) for that table? Example: I have 200 records in Table1--by filtering (i.e., by date) I now have 25 records selected--but when I bring up the report/subreports it still shows the data from all the records in Table1. How can I make only this filtered data from these 25 filtered records show up in the report/subreport--instead of the data from all 200 records?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Linking filtered records/data to a report/subreport
- Thread starter slammer2
- Start date
howdy!
go into the main report. open the properties of the sub-report. you will see the 'link child/master properties' directly below the 'source object property'. there is a wizard to aid in linking your columns. this will USUALLY give you the intended results.
take note: access will sometimes fail to link sub-reports correctly. if you encounter problems, there are a couple recents threads about this subject.
cheers
go into the main report. open the properties of the sub-report. you will see the 'link child/master properties' directly below the 'source object property'. there is a wizard to aid in linking your columns. this will USUALLY give you the intended results.
take note: access will sometimes fail to link sub-reports correctly. if you encounter problems, there are a couple recents threads about this subject.
cheers
- Status
Similar threads
- Locked
- Question
- Locked
- Question