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!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sub-reports

Status
Not open for further replies.
striker73

striker73

MIS
Jun 7, 2001
376
US
How can I set a filter for a subreport? I want the user to be able to click a button and then have the report open with a specific filter applied to three subreports on the report. Any ideas? Thanks!
 
Sort by date Sort by votes
Is it always the SAME filter on each subreport?
As in subReportA always has FilterA
subReportB always has FilterB etc.. ..
If so thew hard code the Filter into the Filter Ppoperty of the Report design that is the subForm in each case.

OR
Is the filter just matching fields in the subReport with fields in the main report?
If so use the LinkParent and LinkChild properties in the subForm control



'ope-that-'elps.

G LS
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Teri Bridges
  • Locked
  • Question
Reports Combobox-List box
Replies
1
Views
404
dhookom
dhookom
breezett93
  • Locked
  • Question
What should be multiple reports is becoming one report with multiple pages 1
Replies
13
Views
363
dhookom
dhookom
PrimoSteve
  • Locked
  • Question
Print Report from a Subform (Tab form) in a Main Form
Replies
1
Views
195
dhookom
dhookom
lameid
  • Locked
  • Question
Docmd.OutputTo Not Exporting Subreport
Replies
2
Views
303
lameid
lameid
lameid
  • Locked
  • Question
Changing Page Footer Main report after section in Sub Report
Replies
1
Views
178
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top